Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi All,
I have a data set like the below,
And I am displaying this data by using Matrix visualization ,
For the categaory "E" there is no data for the month 2017-02 . So the value is Blank in the visual. I wanted to dispaly some text like "NR" in that place.
How could this be achieved, thanks in advance.
Regards,
P.Kalidoss
Solved! Go to Solution.
Hi @sivadoss87
I created a new Calculated table over your data as follows :
NR Table = NATURALLEFTOUTERJOIN( CROSSJOIN( VALUES('Table1'[Category]), VALUES('Table1'[Yr-Mon])), 'Table1')
And then on the new table I created the following Calcuated Measure
New Measure = if(sum('NR Table'[Value])=0,"NR",FORMAT(sum('NR Table'[Value]),"###"))
I could then create a matrix using the new table and measure
Hi @sivadoss87
I created a new Calculated table over your data as follows :
NR Table = NATURALLEFTOUTERJOIN( CROSSJOIN( VALUES('Table1'[Category]), VALUES('Table1'[Yr-Mon])), 'Table1')
And then on the new table I created the following Calcuated Measure
New Measure = if(sum('NR Table'[Value])=0,"NR",FORMAT(sum('NR Table'[Value]),"###"))
I could then create a matrix using the new table and measure
Hi @sivadoss87,
After test, @Phil_Seamark posted is right. If you have resolved your issue, please mark the reight reply as answer, which will help for other people. Thanks for understanding.
Best Regards,
Angelia
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
111 | |
100 | |
80 | |
64 | |
58 |
User | Count |
---|---|
148 | |
111 | |
93 | |
84 | |
66 |