Forum Discussion
matrix displaying data by date using segmentation
I have a timeseries (one year length) for 3 locations, with 1 daly value for each one of them: Besides, I have 3 events categories: Good: Values lower than 50 Regular: Values between 5...
Anonymous , Unpivot the locations, so you will get location and values.
https://radacad.com/pivot-and-unpivot-with-power-bi
Then you can have new bucket column
Switch(True() ,
[Value] < 50 , "Good" ,
[Value] < 100 , "Regular" ,
"Bad")use that in visual
Anonymous , Unpivot the locations, so you will get location and values.
https://radacad.com/pivot-and-unpivot-with-power-bi
Then you can have new bucket column
Switch(True() ,
[Value] < 50 , "Good" ,
[Value] < 100 , "Regular" ,
"Bad")
use that in visual
Genius! the key was to create the conditional columns after pivot, not before....