Forum Discussion
Show Multiple Columns without having to drill down
Good morning,
I have a data set of shift templetes which shows if the template is open or has been filled by someone, along with what day that shift works or not. I am trying to show our open vs filled templates by day of the week, however I can't get it to show all days of the week on one visual, it requires having to drill down showing each day seperatly.
I'm sure the issue is how I have the data set up, just wanted to see if there was a work around.
Thank you.
1 Reply
- amitchandak
Super User
nerickson32 , In this case better to unpivot the data
Unpivot Data(Power Query): https://youtu.be/2HjkBtxSM0g
Or create a measure for each day and use a calculation group
Calculation Groups- Measure Slicer, Measure Header Grouping, Measure to dimension conversion. Complex Table display : https://youtu.be/qMNv67P8Go0