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.
Is it possible to create a dynamic legend slicer? let's say we have a table with various categorical columns (State,Department etc).
I have created a dynamic visual with Date as x axis and y axis changes dynamically (Total Sales, Total Customers), currently it has legends (sales and customers). but i would like to have legends as slicer (department and state).
I have attached a picture below for better understanding.
Solved! Go to Solution.
Hi @Anonymous ,
According to your statement, I think you have added two columns [Customers] and [Sales] in Value field in your visual. So your visual will show customer and sales in Legend.
As far as I know, Power BI doesn't support us to add other column in Legend field when we have added multiple values in that visual. It has used column names from value field as Legend.
What's more? Currently, there are four slicers in your screenshot. So you may want to add four columns into Legend. Power BI only support us to add one column into Legend. If you still want to do that, I suggest you to only add one column, customer/ sales in value field. Then Unpivot [Handing Department],[Status],[Duplicate],[Category] fours columns in Power Query Editor.
Then add the new column into Legend.
Best Regards,
Rico Zhou
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @Anonymous ,
According to your statement, I think you have added two columns [Customers] and [Sales] in Value field in your visual. So your visual will show customer and sales in Legend.
As far as I know, Power BI doesn't support us to add other column in Legend field when we have added multiple values in that visual. It has used column names from value field as Legend.
What's more? Currently, there are four slicers in your screenshot. So you may want to add four columns into Legend. Power BI only support us to add one column into Legend. If you still want to do that, I suggest you to only add one column, customer/ sales in value field. Then Unpivot [Handing Department],[Status],[Duplicate],[Category] fours columns in Power Query Editor.
Then add the new column into Legend.
Best Regards,
Rico Zhou
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
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 |
---|---|
111 | |
95 | |
80 | |
68 | |
59 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |