Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.
Goal: Using scenario slicer (A, B, C options), I'd like to dinamically highlight/mark (not filter out!!) rows on a table/matrix visual with DimTable data (ID, Title)
ScenarioTable
Scenario | Column ID |
A | 1 |
A | 3 |
B | 1 |
B | 2 |
B | 4 |
C | 2 |
DimTable
ID | Title |
1 | Title 1 |
2 | Title 2 |
3 | Title 3 |
4 | Title 4 |
Thank you in advance,
drbr
Solved! Go to Solution.
One suggestion/optimization to final solution @camargos88 provided:
are you using a slicer to filter?
you can set your edit interactions do say how you want the visuals to interact between each other
https://www.youtube.com/watch?v=KQsRHWTF4Bs
Proud to be a Super User!
Thank you. I am aware of this functionallity, yet it does not provide solution as, to my knowledge, table/matrix can only be cross-filtered and not cross-highlighted.
What I try to achieve is:
Scenario A selected: matrix visuals still displays all 4 IDs, but only ID 1 and 3 are highlighted.
Scenario B selected: matrix visuals still displays all 4 IDs, but only ID 1, 2 and 4 are highlighted.
Scenario C selected: matrix visuals still displays all 4 IDs, but only ID 2 is highlighted.
I guess for highlighting, I would have to use conditional formatting (visual interaction cross-highlighting is not available in matrix visual, only cross-filtering).
There are around 100 scenarios in my case.
Thank you,
drbr
are you able to provide some dummy data with a scenario or share your pbix
Proud to be a Super User!
hi, unfortunately you are right there doesn't seem to be a way to do it, unless you employ the conditional formatting which as you say is a pain.
maybe this thread will help if you haven't seen it already.
https://community.powerbi.com/t5/Desktop/highlight-specific-rows-in-matrix/td-p/893600
Proud to be a Super User!
you could also do something like this insead of using the matrix...
what are you after the total, the detail of the id's both?
Proud to be a Super User!
Unfortunatelly the matrix is the only way to go.
Previously supplied link could work, but I have almost 100 scenarios.
I will keep the thread open if some DAX genius cracks it somehow😊
Thank you,
drbr
also i see there is this idea on the ideas forum, maybe vote on it?
Proud to be a Super User!
Voted😎
Excellent. I've just came her to tell, I've manged to solve it myself and the I see this post😁. I practically did it in the same way as you. Such an approach can also work in various similar scenarios.
Well done, Sir!
Regards,
drbr
gotta buy that lotto ticket 🙂
Proud to be a Super User!
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.
User | Count |
---|---|
144 | |
80 | |
65 | |
52 | |
50 |
User | Count |
---|---|
211 | |
87 | |
80 | |
69 | |
60 |