Forum Discussion

o59393's avatar
o59393
Post Prodigy
1 year ago
Solved

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...
Need Help
Show and Tell
  • danextian's avatar
    danextian
    1 year ago

    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

     

     

danextian's avatar
danextian
Super User
1 year ago

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