Combo Report (Tablular + Stack Chart)

[kamini]

Hi folks,

I must create a report combining a line item listing and a Stacked Bar Chart. Please see below,

Ignoring the middle section (Schedule Indicator, Work Indicator, and Implementation Indicator), I need to create this report that shows the first 4-5 columns (On the Left Side) and the Bar or Stack Chart in front of each line item on the right side based on the Duration between Start and End Date. 

I'm a little new with Power BI or left it for a while but coming back to it. Since I only have a couple of days to come up with this report, I thought I should ask this Forum. 

[kamini]

The Data Bar must have a numeric value (WHole NUmber) to appear. Thanks a lot!

[kamini]

This is amazing and it is exactly what I was looking for. I just don't know how to get to the following,

Add data bars

To show data bars based on cell values, select Conditional formatting for the Affordability field, and then select Data bars from the drop-down menu.

In the Data bars dialog, the Show bar only option is unchecked by default, so the table cells show both the bars and the actual values. To show the data bars only, select the Show bar only check box.

You can specify Minimum and Maximum values, data bar colors and direction, and axis color.

[kamini]

I can get to Conditional Formatting options without any problem, which is working great, 

and now my report is exactly what I was asking for except to assign the colors (Green) based on the duration.

 No I don't see a FX button anywhere. 

Thank a lot!

[kamini]

It looks like the latest version of Power BI has the option under Conditioning Formatting. 

[BTSN18]

Honeslty they should probably update the documentation as you're likely on the latest PBI version like me. Do you see a FX button? You can click on that to get the conditional formatting.

[BTSN18 · Accepted solution]

Is this what your looking for? 

https://learn.microsoft.com/en-us/power-bi/create-reports/desktop-conditional-table-formatting#add-d... 

Try the settings of the Table Visual, Visual > Cell Elements > Data Bars