You will find two files in the below folder github.com/SunoMath/Power_Bi/tree/main/Datasets 1. Readme file 2. Sport Products Sales Analysis.xlsx (dataset)
Here is the measure for color -> Color = SWITCH(TRUE(), SELECTEDVALUE(Parameter[Parameter Fields])="'SportProducts'[Units_Sold]",[Units_Sold], SELECTEDVALUE(Parameter[Parameter Fields])="'SportProducts'[Revenue]",[Revenue], SELECTEDVALUE(Parameter[Parameter Fields])="'SportProducts'[Operating_Margin]",[Operating_Margin], SELECTEDVALUE(Parameter[Parameter Fields])="'SportProducts'[Operating_Profit]",[Operating_Profit],BLANK())
This is so good. Thank you.
Thank you.. Glad you found this useful.
Amazing work. thank you
Thank you. Glad you found this useful
@drivenBIdata, The read me file has no data. Can you please share it again?
You will find two files in the below folder
github.com/SunoMath/Power_Bi/tree/main/Datasets
1. Readme file
2. Sport Products Sales Analysis.xlsx (dataset)
Can you please share the file?
PLS MENTION COLOR MEASURE FORMULA
Here is the measure for color ->
Color = SWITCH(TRUE(),
SELECTEDVALUE(Parameter[Parameter Fields])="'SportProducts'[Units_Sold]",[Units_Sold],
SELECTEDVALUE(Parameter[Parameter Fields])="'SportProducts'[Revenue]",[Revenue],
SELECTEDVALUE(Parameter[Parameter Fields])="'SportProducts'[Operating_Margin]",[Operating_Margin],
SELECTEDVALUE(Parameter[Parameter Fields])="'SportProducts'[Operating_Profit]",[Operating_Profit],BLANK())