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.
I'm currently working on a report that has a shape map, a matrix and a card. The card displays the region that has been selected on the map. The table shows companies. I am needing the card to update based on whether one of the other visuals is interacted with, like so:
1. If nothing is selected (ie. nothing in the matrix is selected and no region on the map is selected) then the card reads "All"
2. If a region is selected then the card displays the name of the region.
3. If multiple regions are selected on the map or a company that is present in multiple regions is selected in the matrix, then the card reads "Multiple".
I have the following measure:
Solved! Go to Solution.
Hi @Anonymous ,
You can try this measure:
Measure =
VAR y =
CALCULATE ( DISTINCTCOUNT ( 'Table'[Region] ), ALLSELECTED ( 'Table' ) )
VAR x =
IF (
NOT ISFILTERED ( 'Table'[Region] ) && NOT ISFILTERED ( 'Table'[Company] ),
"All",
IF (
HASONEVALUE ( 'Table'[Region] ),
VALUES ( 'Table'[Region] ),
IF ( y > 1, "Multiple" )
)
)
RETURN
x
Sample file is attached that hopes to help you, please check and try it: Dynamic card value based on other visuals.pbix
Best Regards,
Yingjie Li
If this post helps then please consider Accept it as the solution to help the other members find it more quickly.
Hi @Anonymous ,
You can try this measure:
Measure =
VAR y =
CALCULATE ( DISTINCTCOUNT ( 'Table'[Region] ), ALLSELECTED ( 'Table' ) )
VAR x =
IF (
NOT ISFILTERED ( 'Table'[Region] ) && NOT ISFILTERED ( 'Table'[Company] ),
"All",
IF (
HASONEVALUE ( 'Table'[Region] ),
VALUES ( 'Table'[Region] ),
IF ( y > 1, "Multiple" )
)
)
RETURN
x
Sample file is attached that hopes to help you, please check and try it: Dynamic card value based on other visuals.pbix
Best Regards,
Yingjie Li
If this post helps then please consider Accept it as the solution to help the other members find it more quickly.
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 |
---|---|
111 | |
100 | |
80 | |
64 | |
57 |
User | Count |
---|---|
146 | |
110 | |
93 | |
84 | |
67 |