Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.
I have a matrix visual showing # of surveys taken and the NPS Score - both the # of surveys and the NPS Score are Measures I have created in my table. How can I have the values for the where the NPS AND the # Surveys if they both show 0, then leave those values blank.
As example for May2021 should show as follows:
Survey Type NPS # of Survey
30 Day 17 12
60 Day
90 Day
180 Day
Solved! Go to Solution.
returning 0 for both see below. While 0 could potentially be an NPS Score, so technically if we can just have it show blank for BOTH # of Surveys and NPS when the survey volume is 0.
Assuming your measure name is [NPS] and is some calculation like so.
NPS = SUM ( Table[Column] )
You can trick PowerBI into blanking it out like this.
NPS =
VAR _Value = SUM ( Table[Column] )
RETURN DIVIDE (_Value,_Value) * _Value
Because the DIVIDE returns a blank if it tries to divide by 0 and BLANK() * 0 = BLANK() it should work.
Is it hiding those rows instead or is your measure returning 0 for both? What is the result you are getting now?
returning 0 for both see below. While 0 could potentially be an NPS Score, so technically if we can just have it show blank for BOTH # of Surveys and NPS when the survey volume is 0.
Check out the November 2023 Power BI update to learn about new features.
Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.
Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!