Show any message or blank “card visual” when the value of the slicer is deselected.

  • Published
  • Posted in Power BI
  • Updated
  • 1 min read
  • Tagged as

 Agenda:

  1. Problem Statements
  2. Solution
  3. Problem Statements

I have one slicer and one card visual. So if I select one value from the slicer, it will be reflected on the card visual, but the problem is that whenever I deselect the slicer, it shows me the “(blank)”, so it’s not looking good.

So, whenever the slicer is deselected, it should show me the blank card or any static string like “Please Select Value.”

  1. Solution

Create a new measure as shown below and drag and drop this measure into the card visual.

So, the result of this solution is:

Here we are getting a blank card as we want.

And if we want a static text then create a new measure as shown below and drag and drop this measure into the card visual

So, the result of this solution is:

And now we can see a static string in the card “Please Select Year”.

Conclusion: We can adjust the card’s visual as we want.

Rubika Jadhav

Sr. Data Analyst

Addend Analytics

Addend Analytics is a Microsoft Gold Partner based in Mumbai, India, and a branch office in the U.S.

Addend has successfully implemented 100+ Microsoft Power BI and Business Central projects for 100+ clients across sectors like Financial Services, Banking, Insurance, Retail, Sales, Manufacturing, Real estate, Logistics, and Healthcare in countries like the US, Europe, Switzerland, and Australia.

Get a free consultation now by emailing us or contacting us.

Email Us Or Contact Us