Using Data bars in Table visual or Show Matrix visual as Flat Table

[prabhatnath]

Hi Friends,

I am looking for an option to show the progress percentage (calculated from estimation hrs and completed hrs) in a tabular format. I think we can have a Custom Column for the Progress percentage or a measure and show that in the table visual. But How can we show data bars or a kind of progress bar for the same?

Not sure if we can show the progress bar in the table visual?

And If I have to choose a Matrix visual then I am not sure how can I show flat tabular data similar to a table visual along with the progress bar.

Please advise on this.

Here is the data source. and below is the view that the table visual gives. Can I get a similar view from Matrix Visual as well?

I want to show like below:

Thanks,

Prabhat 

[Ritaf1983 · Accepted solution]

Hi @prabhatnath 

Unfortunately, your data source is locked (you need to modify the sharing and give the access , not just copy the link).
So I will use some dummy of mine 🙂

You can get something like that using conditional formatting and some tricks.
This method works with matrixes and with flat tables.

You can download the example and follow my steps here:Link to the sample file 

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly

[parry2k]

@prabhatnath Yes you can, in conditional formatting, select a data bar, read more it here Apply conditional table formatting in Power BI - Power BI | Microsoft Learn