Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Anonymous
Not applicable

Filter that shows different categories depending on a selection

Hello,

I have this tables

Table_A

Name_Seg
Seg_owner
seg_commerce

 

Table_B

Seg_ownerseg_commerce
Product_1Product_A
Product_2Product_A
Product_3Product_B
Product_4Product_B
Product_4Product_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

1 ACCEPTED SOLUTION
v-eachen-msft
Community Support
Community Support

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.

1-1.PNG1-2.PNG

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.

 

Community Support Team _ Eads
If this post helps, then please consider Accept it as the solution to help the other members find it.

View solution in original post

7 REPLIES 7
v-eachen-msft
Community Support
Community Support

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.

1-1.PNG1-2.PNG

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.

 

Community Support Team _ Eads
If this post helps, then please consider Accept it as the solution to help the other members find it.
Anonymous
Not applicable

That is what I was looking for, thank you so much

piyushszope
Helper I
Helper I

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. 

Anonymous
Not applicable

could you tell me @piyushszope how to upload it? please

You can your file link via One drive or Google drive.

amitchandak
Super User
Super User

Can you explain with an example.

Can you share sample data and sample output.

Mark me @

Anonymous
Not applicable

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

 

 

 
 

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.