Power BI is turning 10, and we’re marking the occasion with a special community challenge. Use your creativity to tell a story, uncover trends, or highlight something unexpected.
Get startedJoin us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.
Hi, I need to populate the message when user selectes in any slicer like year, qtr , week, if there is no data , how can display the "No data" and hide all visual and display only "No Data" message.
I acevihved the populate message with measure like , no sales = if(sales) = blank(), "no data" , " " ) , but when this card measure populates no visual should display on the page , only "no data"should display on the page.
Any help appriciated! Please
Thanks @rajendraongole1 and @Anonymous for solution.but when i do conditional foramting and apply the trasnpersncy , i could not able to click matrix visual when i want to drillthrogh the detailed report.
Hi,
Thanks for the solution @rajendraongole1 provided, and i want to offer some more information for user to refer to.
hello @Bajigntrr , based on your descriotion, you can try the following solution,
Put the no sales measue to the visual filter , then set it to the following.
Best Regards!
Yolo Zhu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @Bajigntrr - To display a "No Data" message specifically when a matrix visual in Power BI, as you already created measure as follows .
MatrixHasData =
IF(
ISBLANK(MAX(Sales[Amount])),
"No Data",
""
)
after implementing the same, when ever there is no data available, it display Text message, to get this done , To hide the matrix visual when there is no data, use conditional formatting on the transparency setting of the matrix.Make any necessary adjustments to the formatting and layout to ensure a seamless user experience.
Did I answer your question? Mark my post as a solution! This will help others on the forum!
Appreciate your Kudos!!
Proud to be a Super User! | |
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
60 | |
58 | |
54 | |
36 | |
33 |
User | Count |
---|---|
79 | |
66 | |
45 | |
44 | |
42 |