Forum Discussion
Line Chart: Conditional Formatting
Hi,
I'm trying to visualise e.g.. sales for a product during a year with campaign periods.
Say the product was on campaign in Q1 and Q3 and not Q2 and Q4, I would like to show this in a line chart with different colours for campaign and not campaign. Is this possible? And can you apply this for several products (lines) in the same chart area?
Kind regards SirLearnALot
Hi Sirlearnalot,
For your scenario, you should create the four measures below to achieve your desired output.
Yes_P1 = CALCULATE(SELECTEDVALUE(Table1[Sales]),FILTER('Table1','Table1'[Campaign period]="Yes"&&'Table1'[Product]=1)) Yes_P2 = CALCULATE(SELECTEDVALUE(Table1[Sales]),FILTER('Table1','Table1'[Campaign period]="Yes"&&'Table1'[Product]=2)) No_P1 = CALCULATE(SELECTEDVALUE(Table1[Sales]),FILTER('Table1','Table1'[Campaign period]="No"&&'Table1'[Product]=1)) No_P2 = CALCULATE(SELECTEDVALUE(Table1[Sales]),FILTER('Table1','Table1'[Campaign period]="No"&&'Table1'[Product]=2))Then you drag these measure to Values Field to create the line chart.
In addition, you could refer to this attachment.
Best Regards,
Cherry
5 Replies
Hi Sirlearnalot,
I'm not very clear about your scenario.
It seems that there is no direct option of conditional formatting for line chart, but we could set the color each line based on legend.
If you do not have the column for legend, we could create the measure to achieve it.
You could have a reference of this similar thread.
If you still need help, please share some data sample so that I can copy and test to get your desired output.
Best Regards,
Cherry
Thank you v-piga-msft !
To explain what I mean:
I want to show Quarter on x, Sales on Y and Product as the legend, but with colour change if Campaign period says yes or no.
Product Sales Quarter Campaign period 1 7000 1 Yes 1 5000 2 No 1 6500 3 Yes 1 4000 4 No 2 80000 1 No 2 15000 2 Yes 2 7000 3 No 2 7500 4 No I saw the post you referred to and it's exactly the result I want, but not sure how to apply it when it's a "4th variable", maybe I can structure the data differently?
Hi Sirlearnalot,
For your scenario, you should create the four measures below to achieve your desired output.
Yes_P1 = CALCULATE(SELECTEDVALUE(Table1[Sales]),FILTER('Table1','Table1'[Campaign period]="Yes"&&'Table1'[Product]=1)) Yes_P2 = CALCULATE(SELECTEDVALUE(Table1[Sales]),FILTER('Table1','Table1'[Campaign period]="Yes"&&'Table1'[Product]=2)) No_P1 = CALCULATE(SELECTEDVALUE(Table1[Sales]),FILTER('Table1','Table1'[Campaign period]="No"&&'Table1'[Product]=1)) No_P2 = CALCULATE(SELECTEDVALUE(Table1[Sales]),FILTER('Table1','Table1'[Campaign period]="No"&&'Table1'[Product]=2))Then you drag these measure to Values Field to create the line chart.
In addition, you could refer to this attachment.
Best Regards,
Cherry
We have this workaround which is simple to implement
Conditional Format a line chart in Power BI - Select Distinct
