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.
Hey all,
I am wondering if there is a way to hide values in a slicer that do not have corresponding data in another table.
Table A has a list of companies, and Table B has a list of office names. In the data model, I have joined the 2 tables via the 'Company ID', and have edited the relationship between them to have "Cross Filter direction" set to 'Both' and "Apply security filter in both directions" is checked.
When I add a 'Slicer' visualization to my report, and want to show the 'Company Name' from Table A, it shows all companies in the table, and I'm trying to have the Slicer show just the companies that have a corresponding record in Table B.
It would seem simple enough to accomplish, and perhaps I am missing something obvious, but can't seem to get the desired result.
Solved! Go to Solution.
Hi @charleszino
Assume the relationship between the two tables is
TableA (One) to TableB(Many)
Then create a calculated column in the TableB, you could use this column in the slicer which only contains the companies that have a corresponding record in Table B.
related = RELATED(TableA[company name])
TableB TableA
Best Regards
Maggie
Hi @charleszino
Assume the relationship between the two tables is
TableA (One) to TableB(Many)
Then create a calculated column in the TableB, you could use this column in the slicer which only contains the companies that have a corresponding record in Table B.
related = RELATED(TableA[company name])
TableB TableA
Best Regards
Maggie
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 |
---|---|
109 | |
99 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
102 | |
87 | |
64 |