Matrix Columns on Power BI visual

[F4936310]

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

[Anonymous]

Hi @F4936310,

Can you please share a pbix or some dummy data that keep the raw data structure with expected results? It should help us clarify your scenario and test to coding formula.

How to Get Your Question Answered Quickly  

Regards,

Xiaoxin Sheng

[F4936310]

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