Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
salexa
Helper II
Helper II

Display in Clustered column chart values from columns as categories

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%

salexa_0-1708620673776.png

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:

salexa_1-1708620873178.png

 

Do you have an idea how I can solve it?

 

Thanks,

Irina

 

1 ACCEPTED SOLUTION
Anonymous
Not applicable

Hi @salexa ,

 

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

vkongfanfmsft_0-1708671195228.png

then create below formula:

Measure = COUNTROWS('Table')

vkongfanfmsft_1-1708671681555.png

 

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.

 

View solution in original post

3 REPLIES 3
Anonymous
Not applicable

Hi @salexa ,

 

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

vkongfanfmsft_0-1708671195228.png

then create below formula:

Measure = COUNTROWS('Table')

vkongfanfmsft_1-1708671681555.png

 

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.

 

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
Super User
Super User

@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

Share with Power BI Enthusiasts: Full Power BI Video (20 Hours) YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.