We are are trying to see % change of each load time side by side and add it to this visual , aslo would like to have option to choose two load times to compate too .
example :want to comapte load tme of 5/18/2023 to 4/24/2023.
All data coming from one data set and no measures has been used.
@FreemanZ Thank you for reply, to explain more and be more clear :
I want to create the below table in Power BI Matrix, so I have week number and Qty , then want to use dax to create unit variance and % variance .
wk 20 | V U | V % | wk 21 | V U | V % | wk 22 | V U | V % | wk 23 | V U | V % | wk 24 | V U |
60 | 0 | 0% | 70 | 10 | 17% | 45 | -25 | -36% | 1 | -44 | -98% | 200 | 199 |
Not sure if fully get you.
Supposing you have a data table like:
try to
1) plot a slicer with a calculated table like:
slicer = VALUES(data[Date])
2) plot a table visual with class column and a measure like:
measure =
CALCULATE(
SUM(data[Value]),
data[Date]=MAX(slicer[Date])
)
-
CALCULATE(
SUM(data[Value]),
data[Date]=MIN(slicer[Date])
)
it worked like: