Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Hi, I have a table visual which shows Sales by Region i.e. North, East.
Sales by Region
What I want to achieve is, that when I select any region from slicer (I have a dropdown slicer of region), the same table show sales data by State of that selected region. (States in place of region in the same table).
I have tried few ways, like tried to create a measure, which can switch column dynamically (switch case, when region = 'east', then state column). Read this article : https://www.nathanprats.com/4-different-ways-to-dynamically-change-tables-rows-in-power-bi/ but this use case seems different. There are many tutorials which show how to dynamically add column which is not the use case here.
What I tried, is that I first checked if any region is selected, if yes then checked if any state is selected:
Any help is much appreciated!
@Anonymous , Based on what I got, Please check if field parameters can help
Power BI Field Parameters — A Quick way for Dynamic Visuals: https://amitchandak.medium.com/power-bi-field-parameters-a-quick-way-for-dynamic-visuals-fc4095ae9afd
Power BI Field Parameters- Measure Slicer and Axis/Dimension slicer: https://youtu.be/lqF3Wa1FllE
Switch TOPN with Field Parameters: https://amitchandak.medium.com/switch-topn-with-field-parameters-299a0ae3725f
Field Parameters- Conditional Formatting
: https://amitchandak.medium.com/field-parameters-conditional-formatting-517aacc23fdf
@amitchandak great! field parameters has solved the problem of changing axis dynamically. But, if I select State in parameter, then it show states of all region
Then, to view state of a particular region, I have to select Region from dropdown slicer. So, it has become a 2 click process. Filtering is happening with slicer, axis is changing with parameter. Is there a way to combine both of these functionalities into 1 slicer, to achieve my actual requirement of doing both filtering and changing of axis as we select region from dropdown slicer.
And, parameter slicer is not effecting rest of the dashboard, as I see in model view, parameter table is not connected with any table.
User | Count |
---|---|
25 | |
11 | |
8 | |
6 | |
6 |
User | Count |
---|---|
27 | |
13 | |
11 | |
9 | |
6 |