Possible to use a single field parameter slicer to control the Column Y-axis and Line Y-Axis?

[ERing]

Hi All,

I have a report that analyzes a marketing and sales funnel. The funnel is volume of Website Visits > Contact Forms Completed > Number of Propects > Appointments Scheduled > Sale Completed.

My report also shows the conversion rate for each part of the funnel:
Website Visits > Contact Forms Completed
Contact Forms Completed > Number of Prospects
Number of Prospects to Appointments Scheduled
Appointments Scheduled to Sale Completed

Currently I have a column and line chart where the x axis is date, the y column axis is volume of website visits, and the y line axis the the conversion rate. I am using a field parameter to dynamically show a different conversion rate depending on the selection.

The ask I have been given is to now also dymically change the volume shown on the y column axis.

The desired result is for someone to select "Website Visits" in the slicer and they would see volume of website visits in the columns and Website Visits > Contact Forms Completed conversion in the line chart. If the user selects "Contact Forms Completed" in the slicer, they will see volume of Contact Forms Completed in the columns and Contact Forms Completed > Number of Prospects conversion in the line chart.

Is this possible to accomplish this?

[v-lgarikapat]

Hi @ERing ,

Thanks for reaching out to the Microsoft fabric community forum.

@Deku 

Thanks for your prompt response

@ERing ,

I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions. If my response has addressed your query, please "Accept as  Solution" and give a 'Kudos' so other members can easily find it.

Best regards,
LakshmiNarayana.

[Deku · Accepted solution]

Have two fields parameters, one for fields and one for measures.

Add a column to the measures table, with the name of the corresponding field. Then create 1:many relationship from the field field parameter to the measure one. Add the two fields parameters to the visual and the field one to the slicer. When you filter by the slicer the measure will also be filtered to the corresponding one