Forum Discussion

BBIUser's avatar
BBIUser
Helper IV
2 years ago

Dynamic text based on few suppressed logic

PBI Experts,

I need to create a dynamic text based on few suppressed logic which is already in the data.

Sample Data:

 

I have created a measure to not to show the data on the bar charts based on the filters created in DAX.
MaskedData = COUNTROWS(FILTER(
'Table1', 'Table1'[Employee Count] <> 0 &&
'Table1'[Masked] <> "Yes"))

 

When the bar chart doesn't show the data, the text should show 'Data Masked' in a card or anyother visual
and when the employee count>1 and Masked=No, then card visual text should be hidden. How to create this?

Any help would be appreciated.

 

Thanks!

6 Replies