Using Different Parameters for different categories

[PollyHalton]

Hey,

I wonder if anyone can help. I wish to create a table like the below

Venue Type	Booking fee	tickets sales	Total
Arena	10	500	510
Pub	2	100	102

Where VenueType and ticketsales are specified within the data

Booking fee is a parameter and Total = Bookingfee + Ticket sales


The booking fee is negotiated so the user needs to be able to enter different values here. Also there are two different levels for booking fee dependant on the Venue type. The user needs to be able to enter different amounts for both and see the Total measure.

The venue types need to presented in the same table and the user should be able to view at the granularity displayed above.

I can get this working using 1 parameter with the Powerbi Parameter function but I can't scale to two. Does anyone have any ideas? 

[Anonymous]

Hi @PollyHalton ,

Power bi not allow you to input multiple value on slicer with 'single value' mode, maybe you can consider to switch slicer to list mode to choose multiple items.

Regards,

Xiaoxin Sheng

[PollyHalton]

I was worried that might be the case. thanks