Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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 |
---|---|
42 | |
28 | |
23 | |
18 | |
16 |
User | Count |
---|---|
54 | |
35 | |
18 | |
18 | |
15 |