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

Join us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.

Reply
rcardenasbc
Frequent Visitor

Fixed line graph of amounts per month

Please can you help me with a line graph where the x axis are the months of the year and the values ​​are the monthly amounts, but if I select a filter by month I want the graph not to change and remain fixed for the entire year (the other graphs do change based on the selected month but I want the one in the line graph not to be modified with the filter), I attach the model table, thanks for the help.

 

MonthMonth NumberData 1Dat2Dat3
January1     7,568.10 123,326.35   (15,209.11)
February2   13,268.10 127,972.25  173,897.68
March3   11,696.08 203,625.80      1,761.34
April4     9,447.04 166,556.95      2,058.60
May5     9,118.74   82,340.65 (120,270.06)
June6   11,579.62               -                  -  
July7   10,339.48               -    326,589.00
August8     9,450.14               -   (275,944.09)
September9     8,397.12               -   (245,195.90)
October10     7,914.24               -       (5,986.00)
November11   10,346.78               -   (302,125.98)
December12   10,147.86               -                  -  
1 ACCEPTED SOLUTION
kpost
Super User
Super User

What you want to do is disable the interactions between the visuals.

 

 

Select the slicer, then select "Format" from the options at the top of the window.

 

On the far left, you'll see "Edit interactions".  Click that.

 

interactions.PNG

 

 

Then turn off interactions between the slicer and the line graph in question.

 

interactions1.PNG

 

///Mediocre Power BI advice, but it's free///

View solution in original post

1 REPLY 1
kpost
Super User
Super User

What you want to do is disable the interactions between the visuals.

 

 

Select the slicer, then select "Format" from the options at the top of the window.

 

On the far left, you'll see "Edit interactions".  Click that.

 

interactions.PNG

 

 

Then turn off interactions between the slicer and the line graph in question.

 

interactions1.PNG

 

///Mediocre Power BI advice, but it's free///

Helpful resources

Announcements
Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.

June 2025 Power BI Update Carousel

Power BI Monthly Update - June 2025

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

June 2025 community update carousel

Fabric Community Update - June 2025

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