Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

How to select columns to visualize using a slicer or drop down?

I have a time series table with multiple columns (each a time serie):   time, col1,col2,col3 00:00, val, val, val 01:00, val, val, val 02:00, val, val, val ...   now I want to have a single l...
Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    Hi Anonymous ,

     I created a sample pbix file(see attachment), please check whether that is what you want.

    1. Unpivot all colxx columns

    2. Create a slicer with Attribute field and a matrix as below screenshot

    If the above one is not what you want, please provide your expected result with samples and screenshots. Thank you.

    Best Regards