Forum Discussion
Dynamic legend only without axis
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.
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 ZhouIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
2 Replies
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 ZhouIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.