Forum Discussion

nidhishah's avatar
nidhishah
Frequent Visitor
5 years ago

Dynamic slicer based DAX as URL for row value

Hi,

 

I have a date slicer in my page and a matrix visual that has "Products" as rows and "Regions" as columns with sales as values and it looks like this:

 

ProductAsiaAfricaNorth AmericaSouth AmericaAustralia
ABC1200 1200 100
PQR500470 500450
XYZ 500  900
DEF600 800200 

 

I need to create a concatenated text (based on the product name and date range that a user selects in the date slicer) and have that URL show up as a column next to the product names.

 

Is this possible?

Thanks

Nidhi

Need Help

4 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    5 years ago

    nidhishah , can you share an example. You should be able to create a new column like

     

    New column = [Date] & " " & [Product]

     

    or

     

    New column = format([Date],"YYYYMMDD") & " " & [Product]

    • nidhishah's avatar
      nidhishah
      Frequent Visitor
      5 years ago

      I am not able to upload a file here. But a derived column can't be based on a visual filter range AFAIK.

      • v-kkf-msft's avatar
        v-kkf-msft
        Community Support
        5 years ago

        Hi,

        Use the following formula to create measure:

        URL = 
var _max = 
  MAXX(
    ALLSELECTED('Product'[Date]),
    'Product'[Date]
  )
var _min = 
  MINX(
    ALLSELECTED('Product'[Date]),
    'Product'[Date]
  )
return 
  CONCATENATEX(
    'Product',
    'Product'[Product]&" "&CONCATENATE(_min&"-",_max)
  )

         However, measure cannot be added to the rows of the matrix, and you can create a separate table visual to display the product and URL.

        If the problem is still not resolved, please provide detailed error information or the expected result you expect. Let me know immediately, looking forward to your reply.

        Best Regards,
        Winniz

        If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.