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
Ashish_Mathur
Super User
Super UserHi,
Share the download link of your PBI file.