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,
my problem is the matrix visual and i read many articles but i got no solution.
My situation is the dependency as shown in the picture with supercustomer and subcustomer.
I want to show this data as shown in the picture "visualizuation" but i don't have a clue how to put the data in the format so that:
- in the red circles (red annotation) the "active status" of the super-customer is shown and
- in the blue circle (blue annotation) the "active status" of the subcustomer is shown.
Is this even possible with the matrix visual or do i nee anything else?
Thanks!
Hey @amitchandak,
this measure worked quite good, but i don't understand why the "active status" of the Supercustomer isn't shown when i expand the Matrix like below.
Do you know a solution for that or is something wrong with my measure?
Thanks!
Hi @Steven_ ,
I could get correct value using amitchandak 's code. Could you please share your pbix file?
Best Regards,
Winniz
@Steven_ , Create a measure like
Switch( True() ,
isinscope(SubCustomer[SubCustomer]) , Max(SubCustomer[Active]) ,
isinscope(SuperCustomer[Customer]) , Max(SuperCustomer[Active]) ,
blank()
)
IsInScope - Switch measure at different levels: https://youtu.be/kh0gezKICEM
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 |
---|---|
112 | |
100 | |
76 | |
74 | |
49 |
User | Count |
---|---|
146 | |
108 | |
106 | |
90 | |
62 |