Matrix Presentation

[ThomasDUDART]

HI,

My idea i more an issue than an idea in my opinion.

When i'm building a matrix table, and i want the table to show my column header even if there is no data on this column it work.

But when i want to do the same things on line header it don't work.

So that's my issue/idea, i want to be able to show my lineheaders, even if there is no data.

Thank you for your Time,

Thomas

[Anonymous]

Hi , @ThomasDUDART 

Line header ? I don't quite understand your needs, can you describe your issue in detail through screenshots or videos ?

Best Regards,
Community Support Team _ Ailsa Tao

[ThomasDUDART]

Hi, I'm sorry it's the first time i used the forum, i did not succeed sharing a screen shot. So i'll try explaining better. So what i mean by line header is the value that we put on a line section of a matrix. It's a value for which my main value will be sorted. For instance : Reason/Year 2018 2019 2020 2021 A 57 34 3 12 B 14 3 7 0 C 0 95 4 5 So in this instance my year (2018 2019 2020 2021) would by my column header and my reason (A,B,C) would be my line header. And what i want is for it to show even if there is no value for this Reason. for Instance : Reason/Year 2018 2019 2020 2021 A 57 3 12 B C 0 4 5 Here i show even if there is no value and 2019 too. But in power BI i can show the year even if there is no value, but not the Reason. That's my problem, i hope it was more clear. Thank you for your Time, Thomas