Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

DAX - USERELATIONSHIP for slicers

Hi,   I would like to get a help on setting up a USERELATIONSHIP function to activate a slicer.   Here is my data model with 3 records only (Table name = QuantityTable). The table contains 4 col...
Need Help
Anonymous's avatar
Anonymous
Not applicable
7 years ago

Anonymous  Thank you for your reply and proposed solution.

I understand your workarounds but this is limited in certain situations, especially my real project contains over 20+ slicers similar to "items" and over 10+ "date related" columns that need to be displayed dynamically in both of the slicers and charts.

 

I tried to search from PBI community and here below posts is a reference case which is exactly the same problem to what I am currently facing:

https://community.powerbi.com/t5/Desktop/Slicer-Filters-reflect-quot-Active-quot-data-relationship-when/td-p/423632

 

Do you have any other ways to solve this problem?

Sorry to borther you again and I really appreciated your great help on this, thanks!

 

 

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Anonymous 

 

Solutions are provided based on the query.

I saw the other query you provided link for and that way is not possible in current data arrangement.

 

However you can modify your current DAX to suit my solution.

I might guide you however I would need entire sample data with visuals arrangements to see the effect of one on other.

 

Thanks, meanwhile if found other solution I will post here.