DAX Help

[irnm8dn]

I am using a Line Chart in my dashboard.  the ideal behavior would be show the visualization as "Blank" unless the user has selected the a specific Campaign Name in the slicer.

I am unsure how to create the behavior and look for help.

Thanks!

[Greg_Deckler]

Generally you handle this with a measure in the format:

Measure = IF(HASONEFILTER(<columnName>),<calculation>,BLANK())

[irnm8dn]

@Greg_Deckler

In this case, the output in the Line Graph is already a calculation I have created.  Does this impact the solution?

Also, can you be a little more explicit in how and where this "new" measure is applied?

Thanks.

[Greg_Deckler · Accepted solution]

Assuming that your calculation is a measure called "My Measure", then you could do this:

Measure = IF(HASONEFILTER(<columnName>),[My Measure],BLANK())

<columnName> you would replace on the column that you want them to filter/slice on.

Put this Measure in place of where you currently have your "My Measure" in your line chart visualization (Values area most likely)

[irnm8dn]

@Greg_Deckler

Perfect, thanks.

One last question.  Is there a way to display a message, when the condition hasn't been met (slicer used).

Such as, "Select Campaign Name to see results"?

Thanks again!

[parry2k]

create another measure to show label.

Label = IF(HASONEFILTER(Table3[Category]),"", "Select Campaign Name to see results") 

[irnm8dn]

@parry2k

Thanks.  And like above, can you tell me how this gets applied relative to @Greg_Deckler direction to include his measure in the Values slot?

Thank you both.

[parry2k]

drop multil row card visual on canvas and in fields add this new measure "Label"

[irnm8dn]

Brillaint!  Thanks.