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.
Hi Guys
I am looking for solution to a request i got in our team. We are doing modeling using different scenarios. Belov is a short sample of how i want the final table to operate.
Lets say, I have 4 different customer categories in Austria and I would like to calculate the impact on the business aplying two different scenarios per category. One scenario "Flat at 18" second is "Same Rate as 17 to 18; Cap 30%".
I was able to create a solution where you can switch between these two different scenarios and the result in the table will adjust. Is there a way I could create an visual that would allow me to do diffrent scenarios per line rather than per column. (see example below. ). I told my team that this is probably not possible in PBI as the fundamental different between pbi and excel is that excel operates on cels and pbi on columns.
I feel this is stupid questions but I wanted to try before
Thanx for your thoughts
Country | Category | 2018 share | Option | 2021 scenario share |
Austria | Apparel and Footwear Specialist Retailers | 18.95% | Same Rate as 17 to 18; Cap 30% | 21.41% |
Austria | Leisure and Personal Goods Specialist Retailers | 5.45% | Flat at 18 | 5.45% |
Austria | Department Stores | 6.73% | Same Rate as 17 to 18; Cap 30% | 5.82% |
Austria | Apparel and Footwear through Internet Retailing | 17.34% | Flat at 18 | 17.34% |
@Anonymousif I undesratnd you correctly are you looking for the following result
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
97 | |
94 | |
74 | |
71 | |
64 |
User | Count |
---|---|
143 | |
109 | |
103 | |
82 | |
74 |