Forum Discussion
Create formula switch measure depending on year selected
Hello, I need your help to create a dynamic measure which can be switched in a table automaticly by the user year selection. Here is the details: I have 2 sorce tables which have the same col...
ChiragGarg2512
Solution Sage
Solution SageAnne14 , This measure should work but introduce a date column somehow, because for multiple selection on slicer there needs to be a distinction. If the table visual just has productName and measure, then multiple selection is going to create a problem. In matrix visual, set rows as product, columns as year and values as measures.
that is what I did : try the matrix visual but I have the error that columns contain multiples where 1 was expected when I select 2 or more years in the slicer 😞 I think the IF function will always require one selected value.. I need some other solution
thanks
- ChiragGarg2512
if year is part of column fields, there would be no need of slicer. If slicer is needed, make a field parameter.