Forum Discussion
Automatically change columns depending on slicer selection
Hi all In the columns of a matrix I have a Year field. I also have a slicer where the user can select the Year. When the user selects a single Year in the slicer, I would like the columns in ...
Hello Velafyko ,
yes, implement field parameters, check it out https://learn.microsoft.com/en-us/power-bi/create-reports/power-bi-field-parameters
If I answered your question, please mark my post as solution, Appreciate your Kudos 👍
Follow me on Linkedin
Vote for my Community Mobile App Idea 💡
I created a field parameter, and edited its DAX. But it does not work. Any idea what is wrong? I get no error message, but the matrix always shows the year column, never month.
AutoMonth=
{
(if (HASONEVALUE(Date[Year])=true,"Month", "Year"),
if (HASONEVALUE(Date[Year])=true,NAMEOF('Date'[Month]), NAMEOF('Date'[Year])),
0)
}