Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreGet certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now
Hello comunity,
I'm having trouble trying to display the result of two different slicers in one table. Basically what I'm having is the following:
The tables are something like this
With the Trading1 and Trading2 tables, individual reports need to be produced and those are working perfectly right now. The reason they are crossed between Company1 and Company2 is because I need to filter the second company through the first one and viceversa. Now, with the summary table, I would like the selection on Company1 and the one on Company2 to be the filter for that one table. Something like this:
If all countries are selected in both slicers, I'll see this:
But if I filter them, I'll see this:
But then, in the summary table, I'd like to see smething like this by using the same slicers from before, not other ones:
I hope I'm making sense.
Is this possible? Can someone help me?
Solved! Go to Solution.
Basically, what was needed was to have the appended table disconnected from the others, and have a measure created for the filtering in this table. The measure uses a SELECTEDVALUE conditioned by the 2 other slicers and works a treat!
Hi,
My preferred approach would be:
Hope this helps.
Basically, what was needed was to have the appended table disconnected from the others, and have a measure created for the filtering in this table. The measure uses a SELECTEDVALUE conditioned by the 2 other slicers and works a treat!
Hello @Ashish_Mathur . Your solution works for my table, but then I'd need to select the two countries from one single slicer. Right? My main requirement is that the slicers for the first table both work to select those 2 countries for the second table (the one that would be appended). So, basically, if I select Italy in slicer 1 and then France in slicer 2, those are the two countries I'll see in the second table. Am I making sense?
Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
User | Count |
---|---|
93 | |
90 | |
84 | |
70 | |
49 |
User | Count |
---|---|
141 | |
120 | |
112 | |
60 | |
58 |