Forum Discussion
Weekly RVtools report - add colour
I find many post on how to add colour to reports, but I can't really wrap my head around it on how I can do it in my dataset.
Hopefully someone can point me in the right directions.
I have made a weekly report that adds many rvtools reports into the dataset.
The table ends up something like this.
| Source | Server | RamGB | Date |
| rvtools-week1 | Server1 | 8 | 7/1-23 |
| rvtools-week2 | Server1 | 8 | 14/1-23 |
| rvtools-week3 | Server1 | 12 | 21/1-23 |
How can I add colour to my report. If RamGB is higher from last week, I would like the number to show up as green. If it is lower, red.
Hi Raggsokk ,
Here are the steps you can follow：
1. Create measure.
Flag = var _select= SELECTEDVALUE('Table'[Date]) var _current= SUMX( FILTER(ALL('Table'), WEEKNUM(_select,2)=WEEKNUM('Table'[Date],2)&&'Table'[Server]=MAX('Table'[Server])),[RamGB]) var _last= SUMX( FILTER(ALL('Table'), WEEKNUM(_select,2)-1=WEEKNUM('Table'[Date],2)&&'Table'[Server]=MAX('Table'[Server])),[RamGB]) return SWITCH( TRUE(), _last>_current,"red", _last=_current,"yellow", "blue")2. Conditional formatting – Background color.
3. Result:
Best Regards,
Liu Yang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
3 Replies
Hi Raggsokk ,
Here are the steps you can follow：
1. Create measure.
Flag = var _select= SELECTEDVALUE('Table'[Date]) var _current= SUMX( FILTER(ALL('Table'), WEEKNUM(_select,2)=WEEKNUM('Table'[Date],2)&&'Table'[Server]=MAX('Table'[Server])),[RamGB]) var _last= SUMX( FILTER(ALL('Table'), WEEKNUM(_select,2)-1=WEEKNUM('Table'[Date],2)&&'Table'[Server]=MAX('Table'[Server])),[RamGB]) return SWITCH( TRUE(), _last>_current,"red", _last=_current,"yellow", "blue")2. Conditional formatting – Background color.
3. Result:
Best Regards,
Liu Yang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
