Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Solved! Go to 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.
Regards,
Frank
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.
Hi @Anonymous,
Please update your formula as below.
SlicerCheck = IF ( ISFILTERED(TrendTable[ReportDate]), "Please select ReportDate", "" )
Regards,
Frank
Hi Frank,
I have updated the measure asd per your suggestion BUT still there is issue.
Attched is the mockup for reference.
Thanks.
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.
Regards,
Frank
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:
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
108 | |
105 | |
88 | |
74 | |
66 |
User | Count |
---|---|
126 | |
111 | |
100 | |
83 | |
71 |