Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hello,
I have this tables
Table_A
Name_Seg |
Seg_owner |
seg_commerce |
Table_B
Seg_owner | seg_commerce |
Product_1 | Product_A |
Product_2 | Product_A |
Product_3 | Product_B |
Product_4 | Product_B |
Product_4 | Product_A |
and I need something like a filter, when I select from table_A Seg_owner the filter shows options
Filter |
Product_1 |
Product_2 |
Product_3 |
Product_4 |
and when I select Seg_commerce the other column is enabled.
Filter |
Product_A |
Product_B |
I do apreciate your ideas,
Thank you in advance!
Best Regards,
@Anonymous
Solved! Go to Solution.
Hi @Anonymous ,
I think you want to show data based on the column header. But in DAX we cannot get column headers for comparison by formula, so I used bookmark.
You could use Ctrl+Left Click to select the bookmark.
Here is the document for your reference.
https://docs.microsoft.com/en-us/power-bi/desktop-bookmarks
Here is my test file.
Hi @Anonymous ,
I think you want to show data based on the column header. But in DAX we cannot get column headers for comparison by formula, so I used bookmark.
You could use Ctrl+Left Click to select the bookmark.
Here is the document for your reference.
https://docs.microsoft.com/en-us/power-bi/desktop-bookmarks
Here is my test file.
That is what I was looking for, thank you so much
I think you should try creating a bookmark and slicer for both the filter options. In that way, you can toggle between both the option. Another way to accomplish this, you can create the hierarchy and use it inside the slicer.
I hope this helps you.
For more help, please upload the demo pbix file of the data.
You can your file link via One drive or Google drive.
Can you explain with an example.
Can you share sample data and sample output.
Mark me @
Hi @amitchandak
Thank yo for you interest.
I can't share the real one, but I'll try to make me understand.
basically what I am looking for are two related filters,
the first one will have seg_owner and seg_commerce as options, When I select seg_ower, the second filter will have the options product_1 to 4 and if I select seg_commerce in filter one, then the second filter will show Product_A to B.
In other words I want to use the same report for two different areas, so the second filter should show the categories they know if they click seg_owner or seg_commerce.
Regards
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
64 |
User | Count |
---|---|
135 | |
122 | |
101 | |
71 | |
61 |