Data Modeling and Visualizations

[Csalinas144]

Hey Guys, I am a bit confused with this report. I have to add a new page to my report and add a chart that depicts a new set of information. The information comes from my Fact Table, which is semi-additive. Meaning one column is the # of Engines ran. The Next Column is a RTY percentage. From what I learned this far is that a semi-additive fact table is not easy to work with. 

The Customer wants me to have the RTY as my column Value. And the line Value to be the amount of engines ran. This needs to be spliced by the Month and Year. 

The Table has the following fields: Month, Year, Line, Station, # of Engines Ran, and RTY. 

I know this is hard to follow. I just need a bit of help. What is more is I created a calculated column and that field is not appearing in the model. 

[Csalinas144]

Semi-Additive Table. How to make a combo chart.

[amitchandak]

@Csalinas144 , Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

what is total of # of Engines Ran, and RTY at different level

[Csalinas144]

@amitchandak I have removed sensitive information. But here is an image of what combo chart I need. Also here is a sample data that will be used for the chart. I am vexed by the percentage Field named "RTY" due to the fact that it is not an additive thing. And I do not know what to do in Power BI, in order, to create this Combo Chart.