Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
Kyle_AspirEDU
Frequent Visitor

Dynamic Line Chart: Using Slicers and Parameters

Good morning, 

 

First, my apologies if this has been asked and answered, but I can't seem to find a guide/tutorial for exactly what I am trying to do. 

 

Second: my goal. 

I would like to create a single-line chart that has a set range of dates (X Cord - dates some from my data) and the Y cord is changed by a Slicer using a parameter I created from several different data points. Basically, I want to use the slicer to change the Y cord showing a different data type within the same line chart.  Below you can see it working (bottom line chart) when I manually add the data point to the chart, but then when I use the slicer, with the parameter, to select a single data point, nothing is displayed. I have made sure the slicer is filtering the correct line chart. 

 

Loom_0q8O9AwtSF.png

 

I think the issue might be that the data that makes up the parameter is not summed like it is in the working line graph. But for the life of me I can't figure out a way to make every data point summed within the parameter. 

 

Your help would be greatly appreciated.

Thank you, 

Kyle 

2 REPLIES 2
amitchandak
Super User
Super User

@Kyle_AspirEDU , Please check field parameters can help

 

Power BI Field Parameters — A Quick way for Dynamic Visuals: https://amitchandak.medium.com/power-bi-field-parameters-a-quick-way-for-dynamic-visuals-fc4095ae9af...
Power BI Field Parameters- Measure Slicer and Axis/Dimension slicer: https://youtu.be/lqF3Wa1FllE
Switch TOPN with Field Parameters: https://amitchandak.medium.com/switch-topn-with-field-parameters-299a0ae3725f

Share with Power BI Enthusiasts: Full Power BI Video (20 Hours) YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

Thank you @amitchandak  for the reply, but I have seen this before, your videos are very helpful, but it doesn't seem to fix the issue I am experiencing. 

 

I can get the line chart to use the slicer/parameter for the X cord (as you have shown in your video), but What I really want is to sum the from each individual data set, from the picture "Tagged Notes" and display that data for each data set, along the X cord of the line chart. 

 

Here is the parameter below. Is there something I can change to sum each data set so that when I use this parameter for the Y cord it will change the data type and display totals for each date that is my X cord?

 

Loom_8teXSyY9LY.png

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.

Top Solution Authors