Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi,
Beginner Power BI user here.
I created 3 hierarchies as following: organization, merchandise, customer.
Now I want to filter the visualization of table base on selected hierarchy (by select either organization, merchandise, customer).
If I select organization-> only organization hierarchy will show up on the table.
Is there anyway to use only 1 table and apply the filter?
Thanks for help in advance !
Hi @thanasarnh,
You could have a try with the custom visual Hierarchy Slicer. You could import in the marketplace.
For how to create the visual, you could have a reference of this video.
In addition, I have a little confused about 'Is there anyway to use only 1 table and apply the filter?'.
Best Regards,
Cherry
Hi @v-piga-msft,
First of all, Thank you for you promptly reply!
However, I tried your solution but it seems like it's not the solution that I'm looking for.
By what I mean is that I would like to dynamically change axis by using list of filter. I'm using hierarchy as an axis for the display table for user to able to drill down the table.
Here is the video which show the result that I want.
https://www.youtube.com/watch?time_continue=1&v=X8Or0-RgeSk
Best regards,
Thanasarn
Hi @thanasarnh,
It is glad that you have solved the problem. Only thing that you'll have to notice, just always accept the replies making sense as solution to your question so that people who may have the same question can get the solution directly.
Best Regards,
Cherry
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
99 | |
82 | |
70 | |
60 |
User | Count |
---|---|
149 | |
114 | |
107 | |
89 | |
67 |