Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Hey there!
I have a problem that I hope someone that is more well-versed in Power-BI can help me with.
Before I start, it might be important to know, that the file get its data from a DirectQuery connection to a SSAS database. I don't currently have access to it and might first be able to get direct access to it in 2-3 weeks.
So i'm working in a PBI report that I haven't built myself.
I have the following measures of data:
I've been asked to set up a combined filter whereby I only show products when:
Chat GPT told me to use "Advanced filtering" and adding second + third conditions using the +AND / +OR functionality:
"
Set up the first condition:
Add a second condition:
Add a third condition for the second scenario:
But I can't see that I have the options of adding second + third conditions in either my browser or desktop versions of PBI.
Chat GPT then advises that I create formulas in DAX instead. Can anyone confirm if that is necessary or if there is a way of doing it with the existing filtering functionalities?
Much appreciated from a Power-BI padawan.
Solved! Go to Solution.
Hi, I made a sample dataset to approximate yours below:
The easiest thing to do is just create a slicer with a hierarchy:
The slicer has the tax and Vendor field. If you put multiple fields in a slicer it creates a hierarchy so, all available values of the tax field as it is on top, then all of the different vendors that have that value somewhere in your table. If you were to put vendor on top it would look like this:
Hope this helps, let me know if you have any issues or further questions.
It works! Thank you so much Toby. You're a lifesaver. Happy NY and godspeed man! 🙂
Hi, I made a sample dataset to approximate yours below:
The easiest thing to do is just create a slicer with a hierarchy:
The slicer has the tax and Vendor field. If you put multiple fields in a slicer it creates a hierarchy so, all available values of the tax field as it is on top, then all of the different vendors that have that value somewhere in your table. If you were to put vendor on top it would look like this:
Hope this helps, let me know if you have any issues or further questions.
User | Count |
---|---|
79 | |
74 | |
44 | |
32 | |
28 |
User | Count |
---|---|
104 | |
93 | |
52 | |
50 | |
46 |