Here's my dataset, including a measure. The native dataset has numeric values by "statistic name". This is obviously ripe for a chart with "Statistic" as the column series. I have a Total Employess Measure whose purpose is to always appear, regardless of what get's filtered on the Statistic field. I want to see a combo chart with two of the statistics (New Starters, Attrition) as bars and one of them (Total Employees) as a line I set it up like this. "Statistic" as the "Column Series", but then this is filtered by Attrition and New Starters (as a page filter) because those are the only one I want to see as bars The Actual problem: even though my Total Employees measure appears in a filtered table, no line values appear on my chart. How do I get the line values to appear on the chart? Perhaps there is a better way to model data for this purpose.

You have not selected total employee that is why it is filtered try with measure having all like Total Employee new = calculate(Statistic[Total Employee],Filter(all(Statistic),[Statistic]="Employee")orTotal Employee new = calculate(sum(Statistic[Value),Filter(all(Statistic),[Statistic]="Employee") Appreciate your Kudos. In case, this is the solution you are looking for, mark it as the Solution.In case it does not help, please provide additional information and mark me with @ Thanks. My Recent Blogs -Decoding Direct Query - Time Intelligence, Winner Coloring on MAP, HR Analytics, Power BI Working with Non-Standard TimeAnd Comparing Data Across Date RangesConnect on Linkedin

Line value missing from combination chart | Microsoft Fabric Community

Forum Discussion

Related content

Tables combine

How to get the conditional formatting for missing combinations

Total value missing in calculated column

Generating Missing Data

missing data