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.
Good day all,
I need some advise please.
I have a custom table as seen below which I want to use for slicers.
The challenge I am having is retrieving only the selected value from the individual slicers. I have disabled the interaction between the slicers so that they would not affect each other but I am not able to retrieve the value on the individual selected slicer.
If all my values from all the slicers are the same then I am returning the value based on the DAX measure but as soon as I select different values then I get Blank() results.
I fully understand why I am getting these blank() results and I am hoping there is a measure that I can use to only display the value of the current slicer as seen in the "Slicer x Desired Value" in the images below i.e.: break it up like disabling the interaction between the slicers.
Custom Table
Results if all slicers are on the same value - based on the dax measure
Results when different slicer values are selected - Also note that the interaction between the slicers are disabled
Slicer 1 Value measure tried but not working
Slicer 2 Value measure tried but not working
Slicer 3 Value measure tried but not working - Not getting a blank but not getting the correct result either.
Slicer 4 Value measure tried but not working
Slicer 5 Value measure tried but not working
Desried values - This is where I am stuck 😞
I am sure and hope it might be something simple where I would not have to create 5 different slicer tables.
@Charles-CW I went ahead and mocked this up. It's definitely an autoexist issue. Even unpivoting doesn't help because of autoexist. You need 5 disconnected slicer tables. The upside is that you don't need to worry about edit interactions. See attached PBIX below signature.
@Greg_Deckler, thank you.
I was hoping to get away from the 5 additional tables.
On the plus side I now don't feel to bad for not being able to get this to work.
@Charles-CW Once you hit an autoexist issue, it's all over. Wish they would allow you to toggle that off...
@Charles-CW Can you post an example file or data as text? I am concerned that this is an AutoExist issue and if that is indeed the case, then the only answer might be to unpivot your rows perhaps.
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 |
---|---|
105 | |
96 | |
79 | |
66 | |
62 |
User | Count |
---|---|
145 | |
113 | |
105 | |
85 | |
65 |