Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Join us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.

Reply
Anonymous
Not applicable

Combine differents scenarios

Hello, everyone!

 

I have the follow data sets.

 

Real Sales until last month;

 JanFevMarAbr.MaiJunJulAgostSetOctSetNovDec
Store 11091098        
Store 21091098        
Store 31091098        

 

Budget1

 JanFevMarAbrMai.JunJulAgostSetOctSetNovDec
Store 1     33333333
Store 2     33333333
Store 3'    33333333

 

Budget2

 JanFevMarAbr.Mai.JunJulAgostSetOctSetNovDec
Store 1     55555555
Store 2     55555555
Store 3'    5555555

5

 

Budget3

 JanFevMarAbr.MaiJunJulAgostSetOctSetNovDec
Store 1     77777777
Store 2     77777777
Store 3'    77777777

 

 

Is possible that I give the user the possibility to select the budget (scenario) dynamically and visualize how the store will performe? 

 

Thank you in advance.

 

Ex.:

      Budget 1Budget 2Budget 2Budget 3Budget 3Budget 3Budget 3Budget 3
 JanFevMarAbr.MaiJunJulAgostSetOctSetNovDec
Store 1109109835577777
Store 2109109835577777
Store 310910983557777

 

7

1 ACCEPTED SOLUTION
adityavighne
Continued Contributor
Continued Contributor

@Anonymous 

  1. Create a seperate table for with Store e.g Store1, 2, ..
  2. Create both 1:* relationship between these tables 
  3. you can give this view using Table/ Metrix as per your preference

View solution in original post

1 REPLY 1
adityavighne
Continued Contributor
Continued Contributor

@Anonymous 

  1. Create a seperate table for with Store e.g Store1, 2, ..
  2. Create both 1:* relationship between these tables 
  3. you can give this view using Table/ Metrix as per your preference

Helpful resources

Announcements
Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.

June 2025 Power BI Update Carousel

Power BI Monthly Update - June 2025

Check out the June 2025 Power BI update to learn about new features.

June 2025 community update carousel

Fabric Community Update - June 2025

Find out what's new and trending in the Fabric community.