cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Frequent Visitor

Compare Data in the Same Column - Stock Market Data

Hi folks,

 

I am looking at stock performance per stock at a monthly level and wanting to compare between 2. An example of the data structure is as follows:

stock data.PNG

I have a slicer that that allows you to select 2 stocks. Based on those 2 stocks, I would like to show on a chart (bar, area, etc) the difference between the performance of those 2 stocks. For example, in January 2020, the difference between stock A and stock B is 4%. If I then chose stock A and stock C, the chart should show -3%. The dataset will have many more stocks than just 3, which is why I had initially set up the data this way. I had looked at the variance visualizations, but they are really set up to have 2 different columns or scenarios. Perhaps with DAX there is a way to build a view of the 2 stocks that are selected with the slicer to have them set up in 2 columns (stock 1 and stock 2)?

 

I am really not sure the best way to solve my problem, any help is very much appreciated, thanks.

1 ACCEPTED SOLUTION
Helper I
Helper I

2 REPLIES 2
Helper I
Helper I

Thank you for your quick response, that worked incredibly well.

Helpful resources

Announcements
secondImage

Congratulations!

We are excited to announce the Power BI Super Users!

Microsoft Ignite

Microsoft Ignite with Arun Ulag

Featured Session Drive Data Culture with Power BI: Vision, Strategy & Roadmap. Register here https://myignite.microsoft.com #MSIgnite #PowerPlatform #Power BI ​

Microsoft Ignite

Microsoft Ignite

Join digitally, March 2–4, 2021 to explore new tech that's ready to implement. Experience the keynote in mixed reality through AltspaceVR!

secondImage

The largest Power BI virtual conference

100+ sessions, 100+ speakers, Product managers, MVPs, and experts. All about Power BI. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors