Forum Discussion
Message should be displayed for Blank Graph
Hello Team,
I am having trouble to display the message for the Blank visualisation. Attaching the graph which is showing nothing for any specific customer selection in the slicer. My requirement is if there is no data for this selection, it will show message like" No Data Available".
Requirement is to display message for Blank visual like below.
Attaching the PBIX file link here for reference. Please help me to resolve this.
https://1drv.ms/u/s!AqNLfMSghxwyhgY6NBS9rDX05xon?e=ub5dx5
It would be highly appreciated for your help on the above topic.
Regards,
Sagar
Hi, sagarsahoo_123
You can try the following methods.
Sample data:
Measure = CALCULATE(SUM('Table'[Value]),FILTER(ALL('Table'),[Type]=SELECTEDVALUE('Table'[Type])))Choosing nothing is like this.
Measure:
Text = IF(SELECTEDVALUE('Table'[Type])=BLANK(),"No Data Available")Put this measure in the Card and close the title of the Card. Set the transparency of the card to 100% again.
Set the font color of the Card, set to white when the slicer is selected, and set to black when not selected.
Color = IF(SELECTEDVALUE('Table'[Type])=BLANK(),"Black","White")Place the Card above the view, preferably not obscuring the original view.
Is this the result you expect?
Best Regards,
Community Support Team _Charlotte
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
1 Reply
Hi, sagarsahoo_123
You can try the following methods.
Sample data:
Measure = CALCULATE(SUM('Table'[Value]),FILTER(ALL('Table'),[Type]=SELECTEDVALUE('Table'[Type])))Choosing nothing is like this.
Measure:
Text = IF(SELECTEDVALUE('Table'[Type])=BLANK(),"No Data Available")Put this measure in the Card and close the title of the Card. Set the transparency of the card to 100% again.
Set the font color of the Card, set to white when the slicer is selected, and set to black when not selected.
Color = IF(SELECTEDVALUE('Table'[Type])=BLANK(),"Black","White")Place the Card above the view, preferably not obscuring the original view.
Is this the result you expect?
Best Regards,
Community Support Team _Charlotte
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.