Forum Discussion
HTML viewer to show filter selections
Hi cpunnett
Could you accept a card visual like this?
Measure =
CONCATENATE (
CONCATENATE ( "insureds", ":" ),
IF (
ISFILTERED ( insureds[insureds] ),
CONCATENATEX ( FILTERS ( insureds[insureds] ), insureds[insureds], "," ),
"all"
)
)
Measure 2 =
CONCATENATE (
CONCATENATE ( "products", ":" ),
IF (
ISFILTERED ( products[products] ),
CONCATENATEX ( FILTERS ( products[products] ), products[products], "," ),
"all"
)
)
Measure 3 =
CONCATENATE (
CONCATENATE ( "states", ":" ),
IF (
ISFILTERED ( states[states] ),
CONCATENATEX ( FILTERS ( states[states] ), states[states], "," ),
"all"
)
)
Measure 4 =
CONCATENATE (
CONCATENATE ( "year", ":" ),
IF (
ISFILTERED ( year2[year] ),
CONCATENATEX ( FILTERS ( year2[year] ), year2[year], "," ),
"all"
)
)
Best Regards
Maggie
Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
The Multi-row card does work, but it's too dynamic in the way it's viewed. I can't see all the selected features it's either this:
or this:
- v-juanli-msft7 years agoCommunity Support
Hi cpunnett
Adding measures in Matrix visual can get similar visual,
If the selected values are too many, you can scroll the bar right/left to see all data.
Please download my file to see how i format this matrix.
Some notes:
Values->turn on "show on values"
Grid->turn off grid for vert/Horiz
ect..
Best Regards
Maggie
Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.- cpunnett7 years agoHelper II
The vert and horiz grids were turned off and I don't see "show on values" in values. I do see "show on rows" which is on. I was hoping to use the HTML, but the matrix will have to do for now, thanks for your input.
- v-juanli-msft7 years agoCommunity Support
Hi cpunnett
Is this problem sloved?
If not, please let me know.
Best Regards
Maggie
Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.