Forum Discussion
Rearrange matrix with 2 values
Hi all
Can I go from this:
Where 2 different values are mixed (capacity, count, capacity, count).
To this?:
(capacity, capacity, count, count).
If so, how can I do it?
Thanks.
hi o59393
This can be done but not out of the box. You will need a disconnected table and extra measures to be able to achieve it. You will also need to use dynamic format strings as you're showing % and count. Lastly, an additional measure for the conditional formatting.
Please see attached sample pbix
4 Replies
hi o59393
This can be done but not out of the box. You will need a disconnected table and extra measures to be able to achieve it. You will also need to use dynamic format strings as you're showing % and count. Lastly, an additional measure for the conditional formatting.
Please see attached sample pbix
Thanks danextian I have submitted an idea to MSFT to hopefully work on some kind of toggle on/off to re-arrange the order of columns.
https://ideas.fabric.microsoft.com/ideas/idea/?ideaid=c8e6d3f4-1a7e-ef11-a4e6-6045bd7cc00a
Appeciate if you can vote.
Regards.
