Siva Mani
-
Dynamic Date Selection in Power BI
- May 12, 2021
- Posted by: Siva Mani
- Category: Power BI
No CommentsI got frequent ask from Biz users to keep the default date range in Power BI Dashboards e.g., last 3,6 months and it should dynamically change based on the current date. We can achieve this requirement with a relative slicer, but there is a limitation to select a custom date range.
-
Power BI Tips: Dynamic Month Slicer Selection in 4 steps
- December 2, 2020
- Posted by: Siva Mani
- Category: Power BI
We used to create a lot of reports based on monthly snapshot data. It requires a mandatory filter based on Year Month and users like to see the latest month data as the default view.
-
Power BI Metadata Extract Using SQL Server Management Studio
- June 26, 2020
- Posted by: Siva Mani
- Category: Power BI
This blog will help to reduce efforts in creating a data dictionary for Power BI datasets. Power BI shared datasets ensure the reusability of the existing dataset/data model.
-
5 ways to check Power BI Usage
- May 4, 2020
- Posted by: Siva Mani
- Category: Power BI
Power BI Usage metrics options will help IT to plan their licensing and capacity. It will also help to identify the critical reports based on users’ access.
-
Power BI Tips: Dual Y Axis in Area and Line Chart
- May 27, 2019
- Posted by: Siva Mani
- Category: Power BI
Power BI is recognized for its elegant visualization capabilities. However, you might require a specific feature/option that you might have experienced in some other BI tool. Here is an option that we have discovered recently – Dual Y axis in Area/Line chart.
-
Power BI Tips: Dynamic title based on a Slicer/ Filter selection
- April 25, 2019
- Posted by: Siva Mani
- Category: Power BI
At times, you get requirements like, to set a dynamic title based on a slicer/filter selection or demand to transfer the selection as a URL parameter. This blog will serve you to set dynamic titles for visuals.
-
Power BI Tips: Schedule Refresh on Composite Models
- April 5, 2019
- Posted by: Siva Mani
- Category: Power BI
Composite Model is a great feature in Power BI. It allows users to consume data from multiple data sources in different connectivity mode. For example, you can build a model in Power BI Desktop that combines the following types of data,
-
Connect to Incorta in Power BI
- March 20, 2019
- Posted by: Siva Mani
- Categories: Next Gen Analytics, Power BI
Incorta is a Next-generation Analytics Platform. Incorta provides a seamless, end-to-end analytics platform. It removes the dependency on star schemas, pre-aggregation, and complex ETL processes. You can connect to Incorta in Power BI desktop with following steps,
-
Power BI Tips: New Filter Pane
- February 6, 2019
- Posted by: Siva Mani
- Category: Power BI
Microsoft Power BI team released a feature with updated filter experience (New filter pane) with Power BI Desktop November 2018 update. The new filter pane feature gives many options to manage filters/filter pane…
-
Power BI Tips: Exasol in DirectQuery mode
- December 25, 2018
- Posted by: Siva Mani
- Categories: Power BI, Technology
We recently explored capabilities of Power BI with Exasol in DriectQuery mode. Interestingly it led us to some positive observations. It performs well and more flexible than Google Big Query. This blog will help you to resolve a few issues which may cause when you try to create BI and analytical report in Power BI with Exasol database in a DirectQuery mode.
- 1
- 2