Add a column of charts to a table?

[Curious1_209]

We have a Tableau visual like the following:

The table has two columns: Class (text) and % of Money Used (decimal such as 8.2 and 0.4). We are migrating from Tableau to Power BI. I am new to Power BI and I know how to create a table visual. How to create a column of bar charts for each Class similar to that in the Tableau visual? Even add a greyish background color as in the Tableau visual?

If there is no straight solution, any workaround?

Thanks for any info!

[tackytechtom]

Hi @Curious1_209 ,

It should work if you rename the second column to something different. Just double click on the column in the Values pane to give it another name.

/Tom
https://www.tackytech.blog/
https://www.instagram.com/tackytechtom/

[Curious1_209]

Thanks for your follow up.  I deleted my earlier reply because I thought you used two columns. By "rename the second column", you mean you created two columns with the same percentage data in each row? 

I have only one column and added it twice to the table. However, if I rename one column, the name of the other column changes too. And when I added conditional formatting, it affects two columns at the same time. 

[tackytechtom]

Hi @Curious1_209 ,

The column that shall show the values needs to have a different summarization level than the one that shows the bars. See the screencast below:

Hope this helps!

/Tom
https://www.tackytech.blog/ 
https://www.instagram.com/tackytechtom/

[Curious1_209]

Thanks for the additional info! 

Regards.

[tackytechtom · Accepted solution]

Hi @Curious1_209 ,

I got partly to a solution:

Click on the          for the column you would like to get the bars for. Then Conditional formatting > Data bars:

Apply the following settings and click ok:

As you can see, I was not able to add a grey background to the bar either. I managed to color the whole column grey though, but I do not believe that is what you are looking for...

Hope this helps you anyway 🙂

/Tom
https://www.tackytech.blog/
https://www.instagram.com/tackytechtom/