Advance your Data & AI career with 50 days of live learning, dataviz contests, hands-on challenges, study groups & certifications and more!
Get registeredGet Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now
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 November 2025 Power BI update to learn about new features.
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!
| User | Count |
|---|---|
| 97 | |
| 70 | |
| 50 | |
| 42 | |
| 40 |