Dynamic column change

[Likhitha]

Hello All,

I created a column like , for top 50 productnames based on sales productnames  will be there and for rest other products "Others"is assigned(col 1)

and another column  top 50 productnames based on quantity sold,productnames will be there and for rest other products "Others"is assigned(col 2)

and another column  top 50 productnames based on Gross Margin ,productnames will be there and for rest other products "Others"is assigned(Col 3)

Now I created a separate table with SALES,QUANTITY and GROSSMARGIN

if i select SALES ,i want col1 in legend in piechart.if selection is QUANTITY col2 should be legend,if i select GROSSMARGIN col3 should be in legend.

How to achieve that??

[Mariusz]

Hi @Likhitha 

Try this video.

https://www.youtube.com/watch?v=gYbGNeYD4OY

Best Regards,
Mariusz

If this post helps, then please consider Accepting it as the solution.

Please feel free to connect with me.
LinkedIn

[Likhitha]

@Mariusz  Nope...I'm having columns and that columns has to be dynamic

[v-deddai1-msft · Accepted solution]

Hi @Likhitha,

Would you please refer to Show Top N and Rest in Power BI and as a workaround, combine bookmark and buttons instead of use slicer:https://blog.crossjoin.co.uk/2018/04/20/dynamically-changing-a-chart-axis-in-power-bi-using-bookmark...

Best Regards,

Dedmon Dai