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...
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