Forum Discussion
PROGRESS TRACKER - By Sectors, Stage & Status
- 1 year ago
Hi Sarasvathi There is no option in the marker color to make it dynamic. There are many option out there to achieve such functionality.
Here is my suggestions.Approach 1:
First Create a clustered column chart and then convert it back to line chart. Find the details below:
Create a static value measure:
Static = 1In x axis place Stages and in y axis place the static measure. You will get visual as follows:
Create a lable color measure:
Label Color = SWITCH( TRUE(), MAX('Table'[STATUS]) = "Completed", "Green", MAX('Table'[STATUS]) = "Inprogress", "Yellow", MAX('Table'[STATUS]) = "Not Started", "Red" )Now go to coloumn section and click fx icon in color option and select field value and place the Label color measure:
After placing lable color , you will get the below image:
Now select the visual and turn this back to line chart. See image below after convert to line chart:
Approach 2:
Use a data lable to identify such status. Now go to data level and turned it on. I have only one series, which is target. Go to value section of the data level and replace default with the custome lable. Try this:
Target Label = IF( SELECTEDVALUE('Table'[STAGE]) = MAX('Table'[STAGE]), "▼", -- Useing windows key + ;, you will get emoji option, from there go to geometric symbol BLANK() )Now you would be able to dynamically color and identify status. You can use either, Rules or Field value option. For rules, add each conditon:
If you would like to use field value then try below code:
Label Color = SWITCH( TRUE(), MAX('Table'[STATUS]) = "Completed", "Green", MAX('Table'[STATUS]) = "Inprogress", "Yellow", MAX('Table'[STATUS]) = "Not Started", "Red" )and you are done. Output are:
1. When no selection of sector:
2. When select perticula sector, which is full complete:
Hope this helps!!
If this solved your problem, please accept it as a solution and a kudos!!
Best Regards,
Shahariar Hafiz
Hi Sarasvathi There is no option in the marker color to make it dynamic. There are many option out there to achieve such functionality.
Here is my suggestions.
Approach 1:
First Create a clustered column chart and then convert it back to line chart. Find the details below:
Create a static value measure:
Static = 1
In x axis place Stages and in y axis place the static measure. You will get visual as follows:
Create a lable color measure:
Label Color =
SWITCH(
TRUE(),
MAX('Table'[STATUS]) = "Completed", "Green",
MAX('Table'[STATUS]) = "Inprogress", "Yellow",
MAX('Table'[STATUS]) = "Not Started", "Red"
)Now go to coloumn section and click fx icon in color option and select field value and place the Label color measure:
After placing lable color , you will get the below image:
Now select the visual and turn this back to line chart. See image below after convert to line chart:
Approach 2:
Use a data lable to identify such status. Now go to data level and turned it on. I have only one series, which is target. Go to value section of the data level and replace default with the custome lable. Try this:
Target Label =
IF(
SELECTEDVALUE('Table'[STAGE]) = MAX('Table'[STAGE]),
"▼", -- Useing windows key + ;, you will get emoji option, from there go to geometric symbol
BLANK()
)
Now you would be able to dynamically color and identify status. You can use either, Rules or Field value option. For rules, add each conditon:
If you would like to use field value then try below code:
Label Color =
SWITCH(
TRUE(),
MAX('Table'[STATUS]) = "Completed", "Green",
MAX('Table'[STATUS]) = "Inprogress", "Yellow",
MAX('Table'[STATUS]) = "Not Started", "Red"
)
and you are done. Output are:
1. When no selection of sector:
2. When select perticula sector, which is full complete:
Hope this helps!!
If this solved your problem, please accept it as a solution and a kudos!!
Best Regards,
Shahariar Hafiz
Thank you for the information. I have tried first approach using the bar chart, however it doesn't work. Fortunately the second method works.