Forum Discussion
jaweher899
Impactful Individual
3 years agoRename 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
- amitchandak
Super 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
- jaweher899
Impactful Individual
no, it'll not working.
- blopez11
Super 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
- jaweher899
Impactful Individual
Any idea, please?