Forum Discussion

klehar's avatar
klehar
Helper V
4 years ago
Solved

Conditional Formatting a Line Chart in Power BI

I'm not sure if this is possible in Power BI, but want to try workarounds   My requirement: For my data given below, I want to color Actuals with a different color and my Non Actuals with a differ...
Need Help
  • PaulDBrown's avatar
    PaulDBrown
    4 years ago

    You can use two measures instead of conditional formatting: one measure for Actuals and the other for the Forecast values (this measure must include the actual values to avoid the blank space in the chart). so:

    Actuals = SUM(Table [Actuals]
    Forecast = SUM(Table [Forecast]) + [Actuals]

     

    Place both measures in the values bucket and then format each measure to your liking:

     

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi Pragati11 sorry to biggie back on this but it kinda aligns.

 

I have a date axis, 1 line in my line graph and able to see forecast in my analytics.  However it displays pff and is greyed out.  Any logic to this? 

 

Pragati11's avatar
Pragati11
Super User
4 years ago

Hi Anonymous ,

 

 Not sure if this is the right thread for you to post your question as i is not related to the question of the original thread.

Can you please create a new thread for your question? In this way you are not taking over other person's thread.