ThomasDUDART's avatar
ThomasDUDART
New Member
4 years ago
Status:
Needs Info

Matrix Presentation

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

2 Comments

  • Anonymous's avatar
    Anonymous
    Not applicable

    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

  • 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