Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
@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]
I am not able to upload a file here. But a derived column can't be based on a visual filter range AFAIK.
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.
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
User | Count |
---|---|
98 | |
87 | |
77 | |
67 | |
63 |
User | Count |
---|---|
110 | |
95 | |
95 | |
64 | |
58 |