Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi all,
wanted to see if it was possible to change the "count of _______" in the values section of the Power BI matrix to showing a "X" if there is a value and blank if there is no value. Thanks for the help!
Yes. Make a measure like this, changing Table and Column to match actual names in your model.
CountMeasure = var mycount = COUNT(Table[Column1])
Return IF(ISBLANK(mycount), BLANK(), "X")
Regards,
Pat
To learn more about Power BI, follow me on Twitter or subscribe on YouTube.
User | Count |
---|---|
60 | |
22 | |
18 | |
18 | |
16 |
User | Count |
---|---|
86 | |
54 | |
54 | |
38 | |
21 |