The ultimate Microsoft Fabric, Power BI, Azure AI, and SQL learning event! Join us in Stockholm, Sweden from September 24-27, 2024.
2-for-1 sale on June 20 only!
Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
I have a table in Power BI that looks like this -
ID | FRUIT | COLOR | TASTE | VALUE |
1 | Apple | Red | Sweet | 10 |
2 | Apple | Green | Sour | 5 |
3 | Orange | Orange | Sweet | 20 |
4 | Grape | Violet | Sweet | 10 |
5 | Banana | Yellow | Sweet | 5 |
6 | Grape | Green | Sweet | 20 |
Like Fruits, Color and Taste, I have close to 50 columns, and I want to create a bar chart that dynamically changes X axis (on click of the column name as per user choice) and plots the sum of price as Y value. I tried to achieve this by creating a second table that has all the column names and its attribute combination (like a helper table with 2 columns), but the view created by that method is not working with the slicers present. (e.g. bar chart for X axis= Fruit, filtered for color = Red).
Is there a way to get this done?
TIA.
Read about the Field Parameters option that was introduced in May 2022.
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the June 2024 Power BI update to learn about new features.
User | Count |
---|---|
125 | |
106 | |
84 | |
64 | |
59 |
User | Count |
---|---|
257 | |
121 | |
116 | |
100 | |
79 |