Weekly RVtools report - add colour

[Raggsokk]

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.

[v-yangliu-msft · Accepted solution]

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

[fmiller]

Hi, Are you using the fabric to import the data from rvtools? or is there a template or something?

Care to share?

Thank you

[Raggsokk]

We have a PowerShell script that runs on a schedule each week.

I then merge all files in the same folder in powerbi.