Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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 |
---|---|
22 | |
11 | |
8 | |
6 | |
6 |
User | Count |
---|---|
25 | |
13 | |
11 | |
9 | |
6 |