Here’s a tip for Power BI that gives you the ability to get more control over placement of numbers in your charts and tables. TIP: Use filter context within a custom measure. In this example I’m creating a chart using a simple data set of Actual and Forecast values. The trick is to create a new custom measure that is context aware so that Actual values and Forecast values get treated separately. Here are some screenshots of the data, the finished chart, the custom measure and the chart settings⦠message me if you’d also like a copy of the PBIX file. Hope it helpsā¦
Amount = var myType = FIRSTNONBLANK(‘data'[Type],”N/A”) return CALCULATE(sum(data[Value]), data[Type] = myType)



