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.
please try to solve this problem.......it is similar to zn function of tableau.
Solved! Go to Solution.
Hello @Anonymous ,
you want to show the word "null" when it's blank ?
if so then you reference your measure that is showing blank here where it says YourMeasure
Measure = IF(ISBLANK(YourMeasure, "Null", YourMeasure)
Proud to be a Super User! | |
@Anonymous
The blanks in your table lack corresponding records, making them inaccessible for evaluation through a measure or any other method. I anticipate that the Power BI team will consider adding a feature to fulfill this requirement. I plan to create an idea request to address this need.
While I understand this doesn't address your issue, I hope it provides the answer you were looking for.
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
@Anonymous
The blanks in your table lack corresponding records, making them inaccessible for evaluation through a measure or any other method. I anticipate that the Power BI team will consider adding a feature to fulfill this requirement. I plan to create an idea request to address this need.
While I understand this doesn't address your issue, I hope it provides the answer you were looking for.
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
Hello @Anonymous ,
you want to show the word "null" when it's blank ?
if so then you reference your measure that is showing blank here where it says YourMeasure
Measure = IF(ISBLANK(YourMeasure, "Null", YourMeasure)
Proud to be a Super User! | |
Check out the July 2025 Power BI update to learn about new features.
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
User | Count |
---|---|
63 | |
62 | |
52 | |
39 | |
24 |
User | Count |
---|---|
85 | |
57 | |
45 | |
43 | |
38 |