Forum Discussion

earltom's avatar
earltom
Frequent Visitor
4 years ago
Solved

Get multiple rows for slicer for selected value - Date

Hi Trust you experts can help me   We have stores that we supply goods to and it often happens that stores are sold and then change name, if users we run a Report we like to see the Stores name as...
Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

    Hi earltom ,

    Please try below steps

    1.my test table

    FACT:

    STORE:

    Model:

     

    2. add a slicer , card visual, create a measure and  add it to card

    Store Name For Month =
VAR cur_month =
    SELECTEDVALUE ( STORE[Month] )
VAR cur_id =
    SELECTEDVALUE ( STORE[Store ID] )
VAR tmp =
    FILTER ( ALL ( STORE ), STORE[Store ID] = cur_id && STORE[Month] <= cur_month )
VAR final =
    CONCATENATEX ( tmp, [Month] & " " & [Store name], "
" )
RETURN
    final

     

    Please refer attached .pbix file.

     

    Best regards,
    Community Support Team_ Binbin Yu
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi earltom ,

Please try below steps

1.my test table

FACT:

STORE:

Model:

 

2. add a slicer , card visual, create a measure and  add it to card

Store Name For Month =
VAR cur_month =
    SELECTEDVALUE ( STORE[Month] )
VAR cur_id =
    SELECTEDVALUE ( STORE[Store ID] )
VAR tmp =
    FILTER ( ALL ( STORE ), STORE[Store ID] = cur_id && STORE[Month] <= cur_month )
VAR final =
    CONCATENATEX ( tmp, [Month] & " " & [Store name], "
" )
RETURN
    final

 

Please refer attached .pbix file.

 

Best regards,
Community Support Team_ Binbin Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.