I am a pretty new user to Power BI and i have encounter a problem with the Slicer that i do not understand.
I want created a new column in a table with the condition:
(Month1 > month2 && month1 = (the Slicer value) ;"YES";"NO")
I have been able to create (Month1>Month2 && Month ="201905" ;"YES";NO")
Is it possible to do this (get the slicer value a variable for my column formula)
Thanks so much for all the help i can recive.
Go to Solution.
Hi @Wresen ,
You cannot do this in a calculated column, as calculated column always returns static value once it has been initilized. However, you can achieve that via a measure.
Measure =IF ( SELECTEDVALUE ( TableName[Month1] ) > SELECTEDVALUE ( TableName[Month2] ) && SELECTEDVALUE ( TableName[Month1] ) = SELECTEDVALUE ( SlicerTable[SlicerColumn] ), "YES", "NO")
Thanks so much for the help.
Now i understand how to retrive the value from the slicer
I belivive i need to rethink how i should do my report now with this new.
Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.
We spoke with Power BI Super User, Greg Deckler, about his charity work
Continue your learning in our online communities.