The ultimate Microsoft Fabric, Power BI, Azure AI, and SQL learning event! Join us in Stockholm, Sweden from September 24-27, 2024.
2-for-1 sale on June 20 only!
Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
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.
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the June 2024 Power BI update to learn about new features.
User | Count |
---|---|
105 | |
101 | |
81 | |
62 | |
54 |
User | Count |
---|---|
249 | |
119 | |
115 | |
94 | |
70 |