Search code examples
powerbidaxdata-analysispowerbi-desktopmeasure

Visualize Two Measures coming from Different tables into a single chart

to learn PowerBI I sought to create a Stock Market App that'll help me monitor my Portfolio.

PBIX File - Here

With some great help from David and Sam! I'm making some progress but the thing is currently I've two tables one with Benchmark data - NiftyHistoricData and a table with all the stock price quotes - StockHistoricData.

Stock and Benchmark line chart

I want to show both of them in the same chart but the thing is my stocks chart is shown individually by using a legend to separate all the stocks.

enter image description here

I want the benchmark data (The light blue one) to show in the stock chart just like any other stock. Is there a way to do the same? Also, it'll be great if I can Slice the Benchmark line chart to disappear away if I deselect it from the slicer.

Solution

  • Unfortunately, the current line chart is a bit limited in this regard. As soon as you add a legend, you're constrained to just the values that exist in that legend. The way to solve this is not to use a legend and instead create a separate measure for each value in GrowthHistoric (e.g. TCS_GrowthHistoric) and then add a final measure for NiftyHistoricGrowth.