Forum Discussion
insert measures on a pivot
Anonymous - Thanks for pointing to the final step switching values to rows, I rarely use Matrix visuals so wasn't aware of this option!
Thanks to all for replys but also Cumulative_MDC_Percent_BI is a Measure and i can't trasform it to column.
there are 4 measure to create the last measures Valutazione_MDC_BI.
Values of the measures changes each time by the filter and if i created a calculated column, it wouldn't work well.
if you want you can find the pbix here to understand better how does it work:
Alberto95 - I'd advise you to have a re-think of how to visualise this. Because what you are trying to do is possible in Power BI only with some very complex and inefficient workarounds.
For example, this blog shows how you can use a measure as a custom label in a bar chart - to acheive the effect of an axis label: https://telefonicatech.uk/blog/pretty-power-bi-creating-dynamic-histograms/
But I couldnt guide you as to how this would be done in a table or matirx with out of the box functionality.
Perhaps this could be done if you used SVG coding or with Deneb, but again this will require a lot of additional learning.
it's not important how to visualise the results by table, matrix, card, chart,... .
it'd could be fine if i can visualise this results in different cards or in different tables but in this moment i can't.
i tried to filter a new measure but i i have to create for each group a different measure.