Forum Discussion
Using Data bars in Table visual or Show Matrix visual as Flat Table
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
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
2 Replies
- parry2kSuper User
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
- Ritaf1983Super User
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