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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

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
v-kongfanf-msft
Community Support
Community Support

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
v-kongfanf-msft
Community Support
Community Support

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

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Fabric Monthly Update - May 2024

Check out the May 2024 Fabric update to learn about new features.

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.