Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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.