How to show this is visual

[Anonymous]

Hi Team,

I have 5 columns,

Project	Baseline	Q1	Q2	Q3	Q4
B	100%	100%	98%
C	100%	100%	89%
D	100%	100%	100%
E	100%	100%	100%
F	100%	100%	100%
G	100%	100%	91%
H	95%	100%	90%
G	95%	100%	93%
H	90%	N/A	80%
I	90%	N/A	N/A

My requiremtnet is to compare each Quarter to Quarter to baseline value and see if they have meet the critirica.

Not sure which visual to use and how to show this.

Thanks in Advance !

[v-angzheng-msft]

Hi, @Anonymous 

It seems like a good idea to use line and clustered column char.

Note that the data need to be formatted as the percentage type.

result:

Please refer to the attachment below for details

Hope this helps.

Best Regards,
Community Support Team _ Zeon Zheng
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@Anonymous , Line or clustered bar line should help .

You can create measures like

average(Table[Baseline])  - average(Table[Q1])

or

average(Table[Baseline])  - average(Table[Q2])

[Anonymous]

@amitchandak ,

I am getting error in my visual

[v-angzheng-msft · Accepted solution]

Hi, @Anonymous 

Has your problem been solved? Does my method above help?
You can create some measures as indicators such as:
Q1-base=AVERAGE('Table'[Q1])-AVERAGE('Table'[Baseline])

Note that in the screenshot above, your baseline is counting, which may indicate that this field is a text type. Please modify the type to percentage to calculate it normally.

It seems like a good idea to use line and clustered column char.

Please refer to the attachment below for details

Edit:
or just to create condition formatting rules to highlight the data in a table to see if they have meet the critirica.

create a measure for each quarter.

_Q1 = IF(SUM('Table'[Q1])>=SUM('Table'[Baseline]),"green","red")

_Q2 = IF(SUM('Table'[Q2])>=SUM('Table'[Baseline]),"green","red")

_Q3 = IF(SUM('Table'[Q3])>=SUM('Table'[Baseline]),"green","red")

_Q4 = IF(SUM('Table'[Q4])>=SUM('Table'[Baseline]),"green","red")

Hope this helps.

Best Regards,
Community Support Team _ Zeon Zheng
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.