Data bars into a table Cell based on other column(s) values

[prabhatnath]

Hi Friends,

I have the below data in my PBI that I show in a table visual.
I need help adding Data Bars in the Estimate column based on the values in the Completed Column ONLY for Task Types of records.
The estimate column is the number of hours estimated and the completed column has how much work is completed. When I tried the Data Bar Conditional Formating for Estimate column I could not see where I can refer to other columns in there. Can you please help me with this? 

ID	Type	Estimate	Completed	Parent
1002	User Story			950
1003	Task	6	4	1002
1004	Task	4	5	1002
1005	Task	2	2	1002
1006	User Story			951
1007	Task	6	0	1006
1008	Task	4	1	1006
1009	Bug	4	2	951
1010	User Story			952
1011	Task	1	1	1010
1012	User Story			952
1013	User Story			952
1014	User Story			952
1015	Task	3	2	1014
1016	Bug			952

Thanks,

Prabhat

[v-jingzhang]

Hi @prabhatnath 

Based on my research, the conditional Data bars can only be based on values in the field itself. It cannot be based on other column values. If you want data bars based on the Completed Column, you need to add data bars in this column. In addition, as only Task Type records have Estimate and Completed values, other type records will not have the data bars because their Completed values are blank. 

Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.

[prabhatnath]

Thanks  v-jingzhang for the input. 
Yes, Data Bar or some visual is needed per row for Task type Records that will represent how much is completed (completed column) out of the estimated value.

Be it as a Data Bar or any other visual that one can suggest. But the visual or representation is needed to check the Type of Record (Task) and Total Value from the Estimated and Completed Value from the Completed column. The visual should be per row basis and need not be in any specific column.

Thanks,

Prabhat   

[v-jingzhang · Accepted solution]

Hi @prabhatnath 

You may try some custom visuals. I found a custom visual Multiple Sparklines that may be helpful.

Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.