topic Re: Weekly RVtools report - add colour in DAX Commands and Tips

Weekly RVtools report - add colour

Raggsokk — Fri, 10 Mar 2023 11:48:06 GMT

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.

Re: Weekly RVtools report - add colour

Anonymous — Mon, 13 Mar 2023 02:32:11 GMT

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

Re: Weekly RVtools report - add colour

fmiller — Fri, 07 Mar 2025 13:55:50 GMT

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

Care to share?

Thank you

Re: Weekly RVtools report - add colour

Raggsokk — Fri, 07 Mar 2025 18:58:43 GMT

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

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