Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!To celebrate FabCon Vienna, we are offering 50% off select exams. Ends October 3rd. Request your discount now.
Hello, this simple problem has been plaguing me for over a week. I don't want the promotions to differ depending on the slicer selection. Is this possible in Power BI?
https://imgur.com/OrsNuwh (with missing Promotions in list)
https://imgur.com/JRxIc2k (correctly display the Promotions in list)
More detail:
So I have only 1 file which I import into PowerBI. No data modeling challenges here.
My dashboard consists of 2 measures, and 3 attributes.
Selected Forecast Sales:
Selected Forecast Sales = SUM('Table'[Forecast Sales])
and my problem child, which we'll get to soon: Current Forecast Sales:
Current Forecast Sales = CALCULATE(SUM('Table'[Forecast Sales]), Quarter = "Current Version")
The three attributes, are as follows:
- Category
-Subcategory
-Promotion Group 1
-Promotion Group 2
-Promotion Group 3
Main problem: Is there a way in DAX that I can force the Promotions to stay visible in the table, so the user can view all promotions that are contributing to the row total for its parent Subcategory?
Thanks!