Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
Hi All,
I'm stuck on a problem and can't figure out.
data for referance is below:-
Category | Sub-Category | C+Sub-Cat. | Value | Index |
A | T | AT | 150 | 1 |
A | T | AT | 146 | 2 |
A | T | AT | 145 | 3 |
A | T | AT | 121 | 4 |
A | T | AT | 114 | 5 |
A | V | AV | 142 | 1 |
A | V | AV | 142 | 2 |
A | V | AV | 110 | 3 |
A | V | AV | 104 | 4 |
A | X | AX | 141 | 1 |
A | X | AX | 123 | 2 |
A | X | AX | 120 | 3 |
A | X | AX | 105 | 4 |
A | X | AX | 100 | 5 |
A | Z | AZ | 148 | 1 |
A | Z | AZ | 126 | 2 |
A | Z | AZ | 119 | 3 |
A | Z | AZ | 102 | 4 |
B | S | BS | 147 | 1 |
B | S | BS | 141 | 2 |
B | S | BS | 134 | 3 |
B | S | BS | 113 | 4 |
B | S | BS | 104 | 5 |
B | S | BS | 101 | 6 |
B | U | BU | 139 | 1 |
B | U | BU | 125 | 2 |
B | U | BU | 119 | 3 |
B | U | BU | 117 | 4 |
B | U | BU | 107 | 5 |
B | W | BW | 148 | 1 |
B | W | BW | 148 | 2 |
B | W | BW | 128 | 3 |
B | W | BW | 125 | 4 |
B | W | BW | 122 | 5 |
B | W | BW | 122 | 6 |
B | Y | BY | 122 | 1 |
B | Y | BY | 113 | 2 |
B | Y | BY | 110 | 3 |
B | Y | BY | 104 | 4 |
B | Y | BY | 102 | 5 |
Hope everyone understand what i'm saying in image.
Regards,
Solved! Go to Solution.
while in Power BI desktop, it is not possible to dynamically show/hide value or visual, one workaround is to to show blank for the value you want to hide.
I make a test and work out these results
“If I select category slicer then hide the value of sub-category”
“If I select sub-category slicer then hide the value of category”
Does these above meet your needs?
If so, create measures like this
MAX OF CATEGORY = IF ( HASONEVALUE ( Table1[Sub-Category] ), BLANK (), CALCULATE ( MAX ( Table1[Value] ), ALLSELECTED ( Table1[Category] ) ) )
MAX1 OF SUBCATEGORY = IF ( CALCULATE ( HASONEVALUE ( Table1[Category] ), ALLEXCEPT ( Table1, Table1[Category] ) ), BLANK (), CALCULATE ( MAX ( Table1[Value] ), ALLSELECTED ( Table1[Sub-Category] ) ) )
Best Regards
Maggie
while in Power BI desktop, it is not possible to dynamically show/hide value or visual, one workaround is to to show blank for the value you want to hide.
I make a test and work out these results
“If I select category slicer then hide the value of sub-category”
“If I select sub-category slicer then hide the value of category”
Does these above meet your needs?
If so, create measures like this
MAX OF CATEGORY = IF ( HASONEVALUE ( Table1[Sub-Category] ), BLANK (), CALCULATE ( MAX ( Table1[Value] ), ALLSELECTED ( Table1[Category] ) ) )
MAX1 OF SUBCATEGORY = IF ( CALCULATE ( HASONEVALUE ( Table1[Category] ), ALLEXCEPT ( Table1, Table1[Category] ) ), BLANK (), CALCULATE ( MAX ( Table1[Value] ), ALLSELECTED ( Table1[Sub-Category] ) ) )
Best Regards
Maggie
Check out the September 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.