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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

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
July 2024 Power BI Update

Power BI Monthly Update - July 2024

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

July Newsletter

Fabric Community Update - July 2024

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