Forum Discussion

F4936310's avatar
F4936310
Frequent Visitor
3 years ago

Matrix Columns on Power BI visual

Hi

I have a POwer BI visual below containing a matrix table. I need to show the %Growth in line with the years (so next to 2022,2023). I have a measure that outputs the number of customers for the last 2 available years and the %Growth measure shows the increase from one year to the next. When I drop the %Growth measure under the "Values" it adds it under the years and displays the column under both years. (One being blank - which is the problem)

If I could even get the blank column to be hidden and only show the %Growth under the latest year would also work.
Any assistance would be highly appreciatted. Thanks

 



Need Help

2 Replies

    • F4936310's avatar
      F4936310
      Frequent Visitor
      3 years ago

      Hi Anonymous 

      Sorry for the delay. Here is the sample pbix file. So I need the Growth% column on the same level as the Years.

      Thank you in advance!!

      Sample pbix file  

      Kind Regards