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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
ppatil
Helper III
Helper III

Changing line color in line chart depending on values selected in slicer

Hi Community..!!

Please help me out to achieve this.

I wants to see the month wise sales in a line chart. The functionality must be such that, data up to specific month selected on slicer should be represented by black line and that after specific month, by red line. 

Please see the below image for your reference.

 

ppatil_0-1634650936382.png

 

Waiting for quick solution.

Thanks in advance..!!

1 ACCEPTED SOLUTION
DataZoe
Employee
Employee

Hi @ppatil ,

 

One way I have done this is to create two measures and place them on the line chart. One for before the selected month, and the other for after the selected month. That way you can color them seperately.

 
DataZoe_0-1634653120945.png

 

Measure = sum('Table'[Value])

 

Before =
var _s = SELECTEDVALUE ( SlicerTable[MonthNumber] ,1)
RETURN
CALCULATE ([Measure],filter('Table','Table'[MonthNumber] <= _s)
)

 

After =
var _s = SELECTEDVALUE ( SlicerTable[MonthNumber],1 )
RETURN
CALCULATE ([Measure],FILTER('Table','Table'[MonthNumber] >= _s)
)

 

Hope this helps. you can even do min()/max() instead of selectedvalue() too for ranges.

Respectfully,
Zoe Douglas (DataZoe)



Follow me on LinkedIn at https://www.linkedin.com/in/zoedouglas-data
See my reports and blog at https://www.datazoepowerbi.com/

View solution in original post

2 REPLIES 2
DataZoe
Employee
Employee

Hi @ppatil ,

 

One way I have done this is to create two measures and place them on the line chart. One for before the selected month, and the other for after the selected month. That way you can color them seperately.

 
DataZoe_0-1634653120945.png

 

Measure = sum('Table'[Value])

 

Before =
var _s = SELECTEDVALUE ( SlicerTable[MonthNumber] ,1)
RETURN
CALCULATE ([Measure],filter('Table','Table'[MonthNumber] <= _s)
)

 

After =
var _s = SELECTEDVALUE ( SlicerTable[MonthNumber],1 )
RETURN
CALCULATE ([Measure],FILTER('Table','Table'[MonthNumber] >= _s)
)

 

Hope this helps. you can even do min()/max() instead of selectedvalue() too for ranges.

Respectfully,
Zoe Douglas (DataZoe)



Follow me on LinkedIn at https://www.linkedin.com/in/zoedouglas-data
See my reports and blog at https://www.datazoepowerbi.com/

Thanks @DataZoe 
Its solved my problem.😊

Helpful resources

Announcements
LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

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

April Fabric Community Update

Fabric Community Update - April 2024

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