Forum Discussion

cpunnett's avatar
cpunnett
Helper II
7 years ago

HTML viewer to show filter selections

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!

Need Help

7 Replies

  • cpunnett's avatar
    cpunnett
    Helper II
    7 years ago

    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>"
  • v-juanli-msft's avatar
    v-juanli-msft
    Community Support
    7 years ago

    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's avatar
      cpunnett
      Helper II
      7 years ago

      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's avatar
        v-juanli-msft
        Community Support
        7 years ago

        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.

  • v-juanli-msft's avatar
    v-juanli-msft
    Community Support
    7 years ago

    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.