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