Display in Clustered column chart values from columns as categories

[salexa]

Hi,

I have in a dataset(sql table) 3 columns : Inprogress, Resolved, Workaround that can have 5 posible values: 0-70%, 70-90%, 90%-100%, 100-120% , >120%

As a requiremnts it's the request to transform the values of these columns in categories and on colum to have a count of n=the number of occurances for each category, something like below:

Do you have an idea how I can solve it?

Thanks,

Irina

[Anonymous · Accepted solution]

Hi @salexa ,

You can start by using the unpivot column in the power query like below:

then create below formula:

Measure = COUNTROWS('Table')

Best Regards,
Adamk Kong

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[salexa]

HI, 

thanks  fo replying, I've check it and it seems to work in  import.

but i forgot to mention that my powerbi report it's linked to a Tabular cube, live connection so I can't apply Power Query.

Tahnks,

Irina

[amitchandak]

@salexa , Are you looking to bucket a measure?

is so refer

Dynamic Segmentation Bucketing Binning
https://community.powerbi.com/t5/Quick-Measures-Gallery/Dynamic-Segmentation-Bucketing-Binning/m-p/1...

Dynamic Segmentation, Bucketing or Binning: https://youtu.be/CuczXPj0N-k