Forum Discussion
jaweher899
3 years agoImpactful Individual
Rename field parameter
Here's teh pbix file https://1drv.ms/u/s!Amd7BXzYs7AVlm0j7IBWB7EZWKIM?e=LTrZMe
I use field parameter
Slice by = {
("Brand", NAMEOF('Product'[Brand]), 0),
("Category", NAMEOF('Product'[Category]), 1),
("Color", NAMEOF('Product'[Color]), 2),
("Continent", NAMEOF('Customer'[Continent]), 3),
("Country", NAMEOF('Customer'[Country]), 4)
}
I add a slicer Month-year
I'd like when I select for the slicer monthyear for example feb 2020, I'd like that in the matrix Brand and category will be renamed as Brand feb 2020 and category feb 2020, is there a way to do it please?
5 Replies
- amitchandakSuper User
jaweher899 , I doubt that. But in the table title you can add the selected month
a new measure = selectedvalue(Date[Month year])
use that in title using fx
- jaweher899Impactful Individual
no, it'll not working.
- blopez11Super User
Reid at Havens Consulting did a video on this. I think this is what you want: https://www.havensconsulting.net/blog-and-media/adding-dynamic-names-to-field-parameters
- jaweher899Impactful Individual
Any idea, please?