Forum Discussion
Helper I2 levels Selector : TONS/Turnover - Current/YTD
blackbool44 unpivot your table
- transform data
- select date column
- right-click, unpivot other columns it will add two columns, attribute, and value, rename these as per your requirement
- close and apply
you can use Attribute column for slicer and rest everything will workI would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!
Super Userblackbool44 , Not sure I got it. But refer if this can help
Super Userblackbool44 unpivot your table
- transform data
- select date column
- right-click, unpivot other columns it will add two columns, attribute, and value, rename these as per your requirement
- close and apply
you can use Attribute column for slicer and rest everything will work
I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!
- blackbool44
Dear parry2k ,
Thanks a lot, I have followed your instructions and unpivoted my table to get the turnover and the tonnage on the same column.
I created a slicer for the type of value (tonnage or turnover).
And then created a disconnected table with my second slicer categories (current/YTD).
Which I activate thanks to a SWITCH dax formula.
For those who want to know more about the switch formula for filtering tables : I followed this great tutorial from Avi Singh : https://www.youtube.com/watch?v=Tn0P_1RLZaIHave a great day !
