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.
Hi everyone.
I'm trying to achieve something that sounds simple, but is troubling me more than it should. I hope some of you can help.
Reducing the problem to it's minimum extension, I am looking forwards something as simple as this:
That is, I want to make use of SELECTEDVALUE() (or any similar DAX expression) to show a column that depends on the user's selection --> ON THAT VERY VISUAL <-- (if it was on a different visual, I could achieve it by using a different, unrelated table). So, in my measure, I have to break the row filter but at the same time keep the "selection from user" filter, hope that makes sense.
Additionally, as a step further, I'd like to have both things, making the column read "A-B" and "B-B", that is, keep the row filter for the first half and break it for the second half.
Could anyone share some info on whether this is achivable?
Thank you in advice for your time.
Cheers,
Alberto.
@Anonymous , If you select a value B, Then your visual will not show value A. If remove interaction then you will not be able to use selectedvalue.
You need an independent table for slicer if you want that
Need of an Independent Table in Power BI: https://youtu.be/lOEW-YUrAbE
Thanks for the reply Amit, but I am not really looking into interactions: I'd like to keep it withing the same visual.
In this case, we can see that B is selected, but A is still shown in the upper row (the visual doesn't "filter" itself, it "highlights" itself, as to speak). Is there a way for the second columns in both rows to say "B", given that B is clicked?
Hi, @Anonymous
You can try steps as below:
1.Add a new slicer table
calculated tabe:
slicer = DISTINCT('Table'[Row])
2.Add a new measure as below:
Slicer Value = SELECTEDVALUE(slicer[Row])
3.apply this measure to table 'Values'
Best Regards,
Community Support Team _ Eason
Thanks for the reply v-easonf-msft.
I understand your solution, but the question was rather pointed towards the process, not the result, and thus why I'd like it to work when clicking on the table itself (to know if we can break row-context while preserving the use of SELECTEDVALUE()).
Anyways, I am guessing it's not possible. Not a big deal 🙂
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 | |
98 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
100 | |
86 | |
64 |