How to create Parameter (Like in Tableau) to select visualizing between two different values?

[Iselghan]

Hi, 

Would appreciate guidance on creating a list parameter that could act like a slicer to allow users to choose between showing two different values (commitments or disbursements). I am used to working in Tableau which allows you to define a parameter and filter for different values. 

Any helos would be greatly appreciated. 

Best, 

IB

[hmericchan]

Hi all, 
Not sure if it's too late to answer this in 2024 😅
Somehow I do come across this situation today and below is my solution: 
To create a custom slicer, you can either create a table by uploading one with Excel as new data source or create it directly using DAX. 

For my case, as the table may change from time to time, I created it with DAX for easy maintenance:

Language = DATATABLE("Language", STRING, {{"EN"}, {"ZH"}})

My use case is use a language slicer to swap two different languages of Type (EN) and Type (ZH), EN as English and ZH as Chinese:

Type =
IF(HASONEFILTER('Language'[Language]),

SWITCH(TRUE,

MIN('Language'[Language])="EN", MIN('OC Utilization & Inventory'[Type (EN)]), MIN('Language'[Language])="ZH", MIN('OC Utilization & Inventory'[Type (ZH)])

),

MIN('OC Utilization & Inventory'[Type (EN)]))

Hope this help 🙂

[Anonymous]

I am trying to create a parameter like one we had in tableau, replicate like a simple Slicer in PowerBi so that the user can select from the dropdown. I am not sure how and if that works in PBi. My field has 2 values and I want to add 3 more and make it a parameter and display it like a slicer on the report

[ImkeF · Accepted solution]

Is this what you're looking for?: http://sqljason.com/2012/11/measure-selection-using-slicers-in.html

Instead of a linked table like in Excel you can use the "Enter Data"-table generator to fill in the names of the measures you want to display in your slicer.

[Iselghan]

Yes and it worked great. Thanks a lot!

[tarun16feb]

Can you please post a workbook with the solution if possible.

[ImkeF]

There is a file to download in the link I've mentioned. It works the same in Power BI.

[Anonymous]

Hi Inke,

that link no longer works. Do you happen to have time to re-explain?

Thanks.