matrix displaying data by date using segmentation

[Anonymous]

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 50 and 100

Bad: Values higher than 100

With that in mind, I need to create a matrix showing the number of Good, Regular and Bad events for each location. Something like this (referential values):

Location	Good	Regular	Bad
Zona RM	20	13	54
Zona Rancagua	2	6	97
Zona Curico	83	26	37

To make it even more intresting, the matrix has to be sortable by date, in order to display the number of events in a given time range. I know it can be done somehow using data segmentation:

I can share the data if needed. I would be very grateful if you could indicate me how to achieve this. Thanks in advance!

@GuyInACube @EnterpriseDNA 

[Ashish_Mathur]

Hi,

Share the download link of your PBI file.

[amitchandak · Accepted solution]

@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]

Genius! the key was to create the conditional columns after pivot, not before....

https://app.powerbi.com/view?r=eyJrIjoiZWM4OTVkNDEtY2ZlMy00MjI0LThlMGQtZjA3ZDMzZTMxYjM3IiwidCI6ImI3O...