Forum Discussion
How to show this is visual
- 5 years ago
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.
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.