Forum Discussion
salexa
Helper II
2 years agoDisplay 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% As a requiremnts it's the request ...
- Anonymous2 years ago
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 KongIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
amitchandak
Super User
2 years agosalexa , 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/1387187#M626
Dynamic Segmentation, Bucketing or Binning: https://youtu.be/CuczXPj0N-k