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

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

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
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

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