Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi all,
I am having a dataset like as shown below,
Customer Order Item Order Number revenue
A Pen 500 10
A Pencil 501 15
B Pen 502 10
C Book 503 100
B Pen 504 20
I want to select dynamic columns through slicer selection
Customer,order item, order number,revenue are my slicer values.
I used unpivot columns in query editor and it is working fine, but the problem is aggregation of revenue doesnt happen when attributes are selected.
My final result should be like below,
1)When Customer and revenue are selected
Customer revenue
A 25
B 30
C 100
2) when customer,order item and revenue are selected,my table is as
Customer order item revenue
A Pen 10
A Pencil 15
B Pen 30
C Book 100
If anyone can find solution, it would be helpful.
Thanks
Solved! Go to Solution.
Hi @Keerthika
It could not be aggregated because all the data types are different in the values column after unpivot all the columns.If you only unpivot Order Number and revenue columns as attachment,it could work well.For your requirement,you may try to use bookmark and buttons to achieve that.
https://radacad.com/bookmarks-and-buttons-making-power-bi-charts-even-more-interactive
Regards,
Hi @Keerthika
It could not be aggregated because all the data types are different in the values column after unpivot all the columns.If you only unpivot Order Number and revenue columns as attachment,it could work well.For your requirement,you may try to use bookmark and buttons to achieve that.
https://radacad.com/bookmarks-and-buttons-making-power-bi-charts-even-more-interactive
Regards,
Hi @v-cherch-msft ,
Using Bookmarks and Buttons aren't the effective solution. I can't use bookmarks and buttons for every columns(I am having nearly 100 columns).
And Why a question is automatically accepted as a solution eventhough I didnt mark as.
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
136 | |
118 | |
101 | |
71 | |
61 |