Dynamic slicer based DAX as URL for row value

[nidhishah]

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 America	South America	Australia
ABC	1200		1200		100
PQR	500	470		500	450
XYZ		500			900
DEF	600		800	200

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

[amitchandak]

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

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]

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]

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