Forum Discussion

PollyHalton's avatar
PollyHalton
Frequent Visitor
7 years ago

Using Different Parameters for different categories

Hey,

 

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

 

Venue TypeBooking fee tickets salesTotal
Arena 10500510
Pub2100102

 

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? 

Need Help

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    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