Hi all
I'm new to power BI and have created basic reports on structed data sets, I'm now trying more ambitions reports that I would be created with TSQL/VBA code.
I have a table of Portfolios that each hold differnet products, some of the portfolios relate to each other (Sister Portfolio) and hold the same products but have a differnt sales amount. I would like to have a report / chart that shows a user selected portfolio and it's related portfolio and the differnce in sales volume in the same product. I would like to differnce to be on a slider for the user to show difference amounts. Example of my data set below.
| Portfolio | SisterPortfolio | Product | Sales Volume |
| Blue | Red | Lamp1 | 200 |
| Red | Blue | Lamp1 | 300 |
| Yellow | Green | Lamp2 | 150 |
| Green | Yellow | Lamp2 | 180 |
| Blue | Red | Lamp2 | 100 |
there are lots are thounsands of products in my real data set, would I best to model in Power query or is there a visual I can use.
I could build a visual if the data set was structued like below, user selected Blue as the portfolio
| | Blue | Red | Diff |
| Lamp 1 | 300 | 200 | 100 |
| Lamp 2 | 100 | 0 | 0 |
Is it possible to do the above, its the differnce column that I'm struggling with.
