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:   Product Asia Africa North Ameri...
Need Help
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.

     

    • nidhishah's avatar
      nidhishah
      Frequent Visitor
      5 years ago

      Thanks v-kkf-msft 

       

      Yes, I know how to get the URL computed as a measure. But that didnt help me since a measure cant be added as row - and i also couldnt do conditional formatting of the row header based on this measure in a matrix. 

       

      I couldnt find a way to show the URL measure value as row - while showing the actual numbered values as columns. 

       

      2 different tables dont work from UI standpoint for my usecase.

       

      Sounds like, there is no way to do what I need. I will just have to stick with adding URL measure as one more value in the matrix and showing the URL repeated for all columns for a given row.

       

      thanks

      nidhi