Forum Discussion
salexa
Helper II
Helper IIDisplay 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 ...
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.
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.
salexaHelper II
Helper IIHI,
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