cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
KyleAdam
Helper IV
Helper IV

Is there a way to make one table appear blank if a slicer is selected?

Sorry for making this confusing, but as you can see below, I have 4 tables (on the right hand side) and two slicers on the left hand slide which are labelled "Deals" and "Customers" 

 

KyleAdam_1-1629209211615.png


Every Customer has a Deal, so if you were to search a Customer, the Deals will filter to that customer, as would the tables next to it (with the correct information). However, when I filter the Deals, everything works but one, the Projects (The top table). This is because there is no relationship between Deals and Projects. So instead it will only show me Projects that are related to that Customer (of the deal) which will affect the math in the tables. 

Is there any way I can make the Projects table BLANK whenever I select a Deal slicer? That would be really helpful. 

 

 

 

 

1 ACCEPTED SOLUTION
parry2k
Super User
Super User

@KyleAdam add a measure to check if a Deal value selected and then use this measure as a visual level filter on the project table where this measure value is 1

 

Is Deal Selected = IF  ( HASONEFILTER ( YourTable[DealColumn] ), 1, 0 )

 

Follow us on LinkedIn

 

Check my latest blog post The Power of Using Calculation Groups with Inactive Relationships (Part 1) (perytus.com) I would  Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

 

Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.

 






Did I answer your question? Mark my post as a solution.

Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.





View solution in original post

6 REPLIES 6
parry2k
Super User
Super User

@KyleAdam as per the screenshot, you didn't filter Is Deal Selected for value 1, how do you expect it to work until I'm missing something.

 

Also, I recommended checking if Is Deal Selected working as expected by adding a card visual, and you didn't even comment on that. 

 

 






Did I answer your question? Mark my post as a solution.

Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.





Thank you @parry2k it works now. 

Apologies I didn't fully understand the code and instruction that you gave me. You did originally say KPI though and I did try that. Obviously I wasn't aware you added in the 1 on the filter. 

parry2k
Super User
Super User

@KyleAdam can you share the screen shot where you added the visual level filter and measure expression.

Put a KPI Card visual and put this measure and check on Deal selection if value changes to 1 and on no selection it goes back to 0






Did I answer your question? Mark my post as a solution.

Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.





Hello @parry2k 

Here is the filter visual for the Project table: 

KyleAdam_0-1629212442088.png

 

And here is the measure you gave me: 

KyleAdam_1-1629212512103.png

Just the exact same as the one you gave except for obviously, the Deal Name location. 
And here is the KPI example, it doesn't appear to be working here either:

KyleAdam_2-1629212845781.png

 






 

 

parry2k
Super User
Super User

@KyleAdam add a measure to check if a Deal value selected and then use this measure as a visual level filter on the project table where this measure value is 1

 

Is Deal Selected = IF  ( HASONEFILTER ( YourTable[DealColumn] ), 1, 0 )

 

Follow us on LinkedIn

 

Check my latest blog post The Power of Using Calculation Groups with Inactive Relationships (Part 1) (perytus.com) I would  Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

 

Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.

 






Did I answer your question? Mark my post as a solution.

Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.





Hi thank you for the reply @parry2k 

I just added that measure and filtered it to the Deal slicer (the column is Deal Name), however, sadly it's still not working. I've put it as a filter on the visual area and there has been no change sadly. It still isn't blank when I select a Deal, which is ultimately what I want. 



Helpful resources

Announcements
Carousel_PBI_Wave1

2023 Release Wave 1 Plans

Power BI release plans for 2023 release wave 1 describes all new features releasing from April 2023 through September 2023.

Power BI Summit Carousel 2

Global Power BI Training

Make sure you register today for the Power BI Summit 2023. Don't miss all of the great sessions and speakers!

BizApps LATAM 2023

Business Application LATAM Summit 2023

Join the biggest FREE Business Applications Event in LATAM this February.

Power Platform Bootcamp

Global Power Platform Bootcamp

In this bootcamp we will deep-dive into Microsoft’s Power Platform stack with hands-on sessions and labs, delivered to you by experts and community leaders.