The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
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 @Anonymous , 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 @Anonymous - 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! | |