HTML viewer to show filter selections

[cpunnett]

I'm trying to show selected filters like this:

So if the user selects more than one criteria, for example Years or states it comma delimits a list of the selections.

I have a measure that does that and put it into an html viewer, but it's not behaving like I expected.  This is what I'm seeing:

It's creating multiple HTML tables per year, does anyone know how to make it just comma delimit a list like the card visual?  Or do you know a better way?

Thanks in advance for your input and time!

[v-juanli-msft]

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.

[v-juanli-msft]

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.

[cpunnett]

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-msft]

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.

[v-juanli-msft]

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.

[cpunnett]

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.

[cpunnett]

This is my table column for the HTML

Filters = 
VAR
    MainDivFormatting = "display:inline-block;float:left;width:248px;height:160px;margin-left:4px;margin-right: 8px;margin-bottom:4px;"
VAR
    TableFormatting = "font-size:8px;border: 1px black solid;border-radius:4px;margin-bottom: 16px; "
VAR
    LeftCellFormatting = "padding: 4px;background-color:white;width:48px;max-width:48px;text-align:right;border-top: 1px solid #DDD;"    
VAR
    RightCellFormatting = "padding: 4px;font-weight:bold;background-color:#EEE;width:200px;border: 1px solid #CCC;"
RETURN
"<div style='" & MainDivFormatting & "' >" &
  "<table style='" & TableFormatting & "' >" &
    "<tr><td style='" & LeftCellFormatting & "' >States:</td><td style='" & RightCellFormatting & "' > " & [State Filter] & "</td></tr>" &
    "<tr><td style='" & LeftCellFormatting & "' >Products:</td><td style='" & RightCellFormatting & "' > " & [Product Filter] & "</td></tr>" &
    "<tr><td style='" & LeftCellFormatting & "' >Years:</td><td style='" & RightCellFormatting & "' > " & [Year Filter] & "</td></tr>" &
    "<tr><td style='" & LeftCellFormatting & "' >Insureds:</td><td style='" & RightCellFormatting & "' >" & [Insured Filter] & "</td><tr>" &
  "</table>" &
"</div>"