In this follow up for the original analysis I used May updates for the US Census indicators. Unfortunately,things are going from bad to worse. Retail is down 15%, while some components of retail are down 40%, 60%, and even 80%. Link to dashboard: https://bit.ly/2RQ2jr0
Dropdown navigation allows us to use the real estate of the report page more efficiently. Traditionally, we use buttons and bookmarks to implement navigation between different pages in our reports, however, as number of pages grows, we eventually start running out of real estate on the page for the menu items. In many other tools, … Continue reading Power BI: How to Implement Dropdown Navigation
We often need to have a dynamic title (page or chart level) that changes based on what the user has selected from the different slicers/filters on the page. In this video, I go over several strategies for accomplishing this task. I start with a very simple one, that requires no knowledge of DAX and then … Continue reading Power BI & DAX: How to Implement Dynamic Page and Chart Titles
How to get to the log files when using SAP BW as the data source ? I answer this in the post below. https://youtu.be/7WfFDGfR6v4
Calculation Groups is a powerful modeling capability in Power BI that allows us to dramatically reduce the number of measures in a model. Calculation Groups also have a dynamic formatting feature that allows us to specify a different format for our measures ($$ vs. %) on the same chart.
In this post, I cover things I have learnt and best practices using SAP Connectors in Power BI. Direct Query vs Import mode, Relational vs Multidimensional mode... etc. https://youtu.be/w2Vt-oGhmxU
In this post, I cover the steps to use parameters to control dataset size. Check it out. https://www.youtube.com/watch?v=7ipslDgCtss&feature=youtu.be