Forum Discussion
Pass a text parameter in report
Hello,
I want to pass a text parameter to a report in order to filter the data by this parameter in report view (What If Parameter).
I have made a calculated column where the data to be shown with IF statement with a logical test form the parameter but for the moment I can enter in parameter list only number values. I think this is not working as well, beacouse in the calc column - DATA, the values are not chaning when i choose another oprion from the paramter.
At the moment is like this:
Parameter: Type;
Options: 1,2,3
I want to be
Parameter: Type;
Options: Quality, Sales Amount, Margin
The idea is the whole report to be shown for a specific type of data, not to make 3 different reports for each type of data.
Thanks a lot!
Anonymous,
What if parameter is not suitable for your scenario.
In your scenario, create a new table containing the measure name(Quality, Sales Amount, Margin). Add the column of this new table into a slicer so that you can select which measure to display.
And in your original table, you would need to create a measure using the formula below, for more details, please review this blog: http://breaking-bi.blogspot.sg/2016/06/power-bipowerpivot-using-slicers-to.html .
selected measure = IF(HASONEVALUE(NewTable[Column]),SWITCH(FIRSTNONBLANK(NewTable[Column],NewTable[Column]),"Quality",SUM(OriginalTable[Quality]),"Sales Amount",SUM(OriginalTable[Sales]), "Margin",SUM(OriginalTable[Margin])),blank())
Regards,
Lydia
3 Replies
Anonymous,
What if parameter is not suitable for your scenario.
In your scenario, create a new table containing the measure name(Quality, Sales Amount, Margin). Add the column of this new table into a slicer so that you can select which measure to display.
And in your original table, you would need to create a measure using the formula below, for more details, please review this blog: http://breaking-bi.blogspot.sg/2016/06/power-bipowerpivot-using-slicers-to.html .
selected measure = IF(HASONEVALUE(NewTable[Column]),SWITCH(FIRSTNONBLANK(NewTable[Column],NewTable[Column]),"Quality",SUM(OriginalTable[Quality]),"Sales Amount",SUM(OriginalTable[Sales]), "Margin",SUM(OriginalTable[Margin])),blank())
Regards,
Lydia