welcome to XRM blog

Keep in touch with latest CRM/ERP articles

To remain competitive your organisation must be efficient across the business process spectrum. To do so you need to take sound decisions based on a balance between the cost and risk. To do so you will be heavily dependent on your content management in itself needs...

image
Blog

Power BI - How to Add Data Bars in a Table

By Prashant Sharma on 9/27/2018

Power BI - How to Add Data Bars in a Table

Note: To follow this blog you should have a basic knowledge of Power BI Desktop.

I have used SQL Server Database to get the data. I bound dataset with table visualization. Then my requirement is to add Data Bars for Margin Field to give it a better understanding of Margins. Before moving forward, I would like to inform you that Data Bars can only be applied on Numeric fields.

 I have bound dataset with a table and it looks like added screenshot below:

Now I need to add Data Bar on Margin Column. You need to follow below steps to Add Data Bars mentioned below:

Step 1: You need to Expand Visualisation after selecting Table.

Step 2: Select Format on the right panel next to Field tab.

Step 3: Expand Conditional Formatting section.

Step 4: You will see a dropdown of field coming under Conditional Formatting. Select a numeric field for which you want to see Data Bar. In my case, I selected Margin.

Step 5: Toggle the Data Bars option to set it as On

Step 6: You will see Advanced controls button below. Click on it.

Step 7: Another window will appear where you can see multiple options for Data Bars.

You can set these options according to your requirement. Options are self-explanatory.

After clicking on OK, I got Table with Data Bars as below:

I hope this will help you in adding Data Bars to a Table in Power BI.

Microsoft Power BI
Power BI
Blog Calendar
Blog Calendar List
2022 Apr  1  1
2022 Mar  0  1
2022 Feb  1  1
2022 Jan  1  1
2021 Dec  2  1
2021 Nov  1  1
2021 Oct  0  1
2021 Sep  7  1
2021 Aug  29  5
2021 Jul  31  4
2021 Jun  220  5
2021 May  22  3
2021 Apr  317  3
2021 Mar  44  5
2021 Feb  609  7
2021 Jan  557  9
2020 Dec  186  7
2020 Sep  52  3
2020 Aug  281  3
2020 Jul  83  1
2020 Jun  53  3
2020 Apr  31  3
2020 Mar  11  2
2020 Feb  25  5
2020 Jan  30  7
2019 Dec  15  4
2019 Nov  12  1
2019 Jan  33  3
2018 Dec  38  4
2018 Nov  68  3
2018 Oct  17  3
2018 Sep  691  11
2018 Aug  6  2
2018 Jun  11  1
2018 Jan  68  2
2017 Sep  573  5
2017 Aug  17  1
2017 Jul  17  2
2017 Jun  56  2
2017 May  21  1
2017 Apr  34  2
2017 Mar  120  4
2017 Feb  555  4
2016 Dec  188  3
2016 Nov  492  8
2016 Oct  266  10
2016 Sep  399  6
2016 Aug  39  1
2016 Jun  1812  6
2016 May  105  3
2016 Jan  71  2
2015 Dec  400  6
2015 Nov  4  1
2015 Oct  13  1
2015 Sep  1412  6
2015 Aug  14  1
2015 Jul  127  2
2015 Jun  10  1
2015 May  20  1
2015 Apr  28  3
2015 Mar  78  3
2015 Jan  5303  4
2014 Dec  17  1
2014 Nov  2241  4
2014 Oct  66  1
2014 Sep  106  2
2014 Aug  5049  1
2014 Jul  48  2
2014 Apr  2504  12
2014 Mar  298  19
2014 Feb  241  8
2014 Jan  1510  16
2013 Dec  21  2
2013 Nov  679  2
2013 Oct  252  3
2013 Sep  11  1
2013 Aug  38  3
2013 Jul  210  1
2013 Apr  50  6
2013 Mar  2078  10
2013 Feb  316  4
2013 Jan  277  2
2012 Nov  50  2
2012 Oct  474  10
Tag Cloud
Interested in our services? Still not sure about project details? get a quote