Empty Line and Stacked column chart with a slicer and display message

[Anonymous]

Hi,

I have  the below measure to blank  the Line and Stacked column chart when no Report Date slicer is not selected

SlicerCheck = IF ( ISFILTERED(TrendTable[ReportDate]), BLANK(), "" )

Need help on updating the below measure.

When Report Date slicer is not selected, I want to display a message like "Please select ReportDate" when Line and Stacked column chart is blank. how do i update the measure ?

Attached is expected behaviour mockup.

[v-frfei-msft · Accepted solution]

Hi @Anonymous,

This measure cannot be add to Line and Stacked column chart. Here we can add it to a card to work around.  And  I made an update of the formula, it should be like this.

SlicerCheck = IF ( ISFILTERED(TrendTable[ReportDate]),"","Please select ReportDate")

For more details, please check the pbix as attached.

https://www.dropbox.com/s/e0170bp3elqw6av/Empty%20Line%20and%20Stacked%20column%20chart%20%20with%20a%20slicer%20and%20display%20message.pbix?dl=0

Regards,

Frank

[v-frfei-msft]

Hi @Anonymous,

Please update your formula as below.

SlicerCheck = IF ( ISFILTERED(TrendTable[ReportDate]), "Please select ReportDate", "" )

Regards,

Frank

[Anonymous]

Hi Frank,

I have updated the measure asd per your suggestion BUT still there is issue.

Attched is the mockup for reference.

Thanks.

[v-frfei-msft · Accepted solution]

Hi @Anonymous,

This measure cannot be add to Line and Stacked column chart. Here we can add it to a card to work around.  And  I made an update of the formula, it should be like this.

SlicerCheck = IF ( ISFILTERED(TrendTable[ReportDate]),"","Please select ReportDate")

For more details, please check the pbix as attached.

https://www.dropbox.com/s/e0170bp3elqw6av/Empty%20Line%20and%20Stacked%20column%20chart%20%20with%20a%20slicer%20and%20display%20message.pbix?dl=0

Regards,

Frank

[Anonymous]

Hi Frank,

Need inputs please.

I have used the below updated measure  suggested by you,   but the issue is when i select the Report Date nothing is shown in the chart.

SlicerCheck = IF ( ISFILTERED(TrendTable[ReportDate]),"","Please select ReportDate") 

 So to fix this i have tried the other way which is kind of working  but still there is  an issue.   Attached the mockups below for reference.

SlicerCheck = IF ( ISFILTERED(TrendTable[ReportDate]),BLANK(),"Please select ReportDate") 

1.    As suggested i have used Card visual to display the message.  I am able to Empty Line and Stacked column chart &  display the message  when  no Report Date is selected.

2.  when i  select the Report Date,  I am able to display the chart data.  But  the issue is I see  text  as  Blank () Need help to fix this

3.   As mentioned above, the Measure I used:

[Anonymous · Accepted solution]

Hi Frank,

I was able to fix the issue using a table visualization instead of Card.

Below are the steps i followed.

1.  Used a table visualization and   

           a) mapped with SlicerCheck measure   

              SlicerCheck = IF ( ISFILTERED(TrendTable[ReportDate]),BLANK(),"Please select ReportDate") 

           b) Table Format -  I have set the Column headers Font to White color to hide the Header.

2.  Select Line and Stacked column chart visualization,  drag the SlicerCheck measure to Visual filters and set it to is blank and click apply filter.

3. Save the Report.  Try to select one of the Report Date from the slicer.  Below is the mockup working behavior.

 

4.  Unselect the Report Date from the slicer, the chart is blank with a message displayed. 

 Below is the mockup working behavior.