cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
zhouxiao198719
New Member

Show records do not match the slicer selection

Hi,

 

I encountered a problem about slicer selection. For simplicity, I have below data for example.

typeapp name
Aapp1
Aapp2
Aapp3
Aapp4
Bapp5
Bapp6
Bapp7
Bapp8
Bapp9
Capp10
Capp11
Capp12
Capp13
Capp14

I created a slicer with type and a table with appname. What I want to achieve is when I select type A for example, I want the table show from app5 to app14 which belong to type B and C.

Anyone can help me on this?

Thank you.

 

Regards,

Harry

1 ACCEPTED SOLUTION
CNENFRNL
Community Champion
Community Champion

5 REPLIES 5
CNENFRNL
Community Champion
Community Champion

Thank you. It works on my side. 

TheoC
Memorable Member
Memorable Member

Hi @zhouxiao198719 

 

To achieve this, you can use something like the following:

 

TheoC_0-1635289682814.png

Ultimately, you want to create a Table2 that has the "Type" and the "Result" as follows:

TheoC_1-1635289765246.png

Establish the relationship as follows:

TheoC_2-1635289789586.png

 

Also, when you do not have anything selected, all of your records will be present like below:

TheoC_0-1635306610989.png

 

Hope this helps 🙂

 

Theo

If I have posted a response that resolves your question, please accept it as a solution to formally close the post.

Also, if you are as passionate about Power BI, DAX and data as I am, please feel free to reach out if you have any questions, queries, or if you simply want to connect and talk to another data geek!

Want to connect?  www.linkedin.com/in/theoconias

Thanks TheoC. It helps a lot. But my case is the type colume is changing every day, so I cannot manually add results field in. I use concatenatex to sort this out. So Thank you very much.

@zhouxiao198719 makes complete sense. Another option that can mitigate the need to manually manipulate is to use SUMMARIZE (dax) or Grouby (Power Query) to automate establish the secondary table and its values. But, in saying that, @CNENFRNL solution is pretty awesome. Only recommendation is, if you want your users to see all records prior to making a selection, just modify the solution a touch.

 

All the best!

 

Theo

 

If I have posted a response that resolves your question, please accept it as a solution to formally close the post.

Also, if you are as passionate about Power BI, DAX and data as I am, please feel free to reach out if you have any questions, queries, or if you simply want to connect and talk to another data geek!

Want to connect?  www.linkedin.com/in/theoconias

Helpful resources

Announcements
Power BI December 2021 Update_carousel 768x460.jpg

Check it Out!

Click here to read more about the December 2021 Updates!

User Group Leader Meeting January 768x460.png

Calling all User Group Leaders!

Don't miss the User Group Leader meetings on January, 24th & 25th, 2022.

Jan 2022 Dev Camp 768x460 copy.png

Power BI Dev Camp- January 27th, 2022

Mark your calendars and join us for our next Power BI Dev Camp!

Top Solution Authors
Top Kudoed Authors