Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I am new to Power Bi, and I am familiarizing myself with this environment. I am faced with the following difficulty: I would like, from a drop-down list like the one below,
to select and compare 2 indicators (in the example above, "Balance" and "Contract Count"), according to a dimension table (in the example below, "Branch")
The values of the indicators are contained in "card" type visualisations :
The dimensions come from the tables in Power Bi Desktop.
Thanks in advance to indicate me how to solve this.
Solved! Go to Solution.
This would be possible using a parameter table and multiple measures. This can be quite involved depending on how many permutations you have, KasperOnBi has a blog post where he applies the same technique to a slightly different issue
https://www.kasperonbi.com/dynamically-switching-axis-on-visuals-with-power-bi/
You may also be able to do it with bookmarks but it would be a lot of bookmarks to make.
This would be possible using a parameter table and multiple measures. This can be quite involved depending on how many permutations you have, KasperOnBi has a blog post where he applies the same technique to a slightly different issue
https://www.kasperonbi.com/dynamically-switching-axis-on-visuals-with-power-bi/
You may also be able to do it with bookmarks but it would be a lot of bookmarks to make.
Dear Thomas Foster, thank you very much for your solution. It has been very helpfull. My problem has been solved.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
115 | |
100 | |
88 | |
68 | |
61 |
User | Count |
---|---|
152 | |
120 | |
102 | |
87 | |
68 |