Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Hi Community,
I need a help… I newbie in Power BI and have de following case:
I have 2 slicers (Real, Comparative) filtering different calendars dimensions (dCalendar, dCalendarComp). The slicer Real, will be used to calculate a Measure (M1 = SUM(prod)) and the slicer Comparative, will be calculate another measure (M2 = SUM(prod)). Want to highlighted that M1 and M2 are calculated based on differents periods selecteds on slicer. Below it’s the model that I’m using.
In my table fact, I have a column named FLAG. In this column, just have the values 0 or 1. Based on these values, I need calculate a new column (named Index) following the condition: If the value of the FLAG = 1, then the value of the Index = 1, else I need divide M1 per M2 (M1/M2).
The problem is: When the slice is change the column doesn't recalculated to the new period. Can I create a dynamic column based on slicer? If can’t, have a workaround for this?
Columns are not dynamic, they are only calculated at the time of data load/refresh. You need to create a measure.
Check out the July 2025 Power BI update to learn about new features.
User | Count |
---|---|
24 | |
9 | |
7 | |
6 | |
6 |
User | Count |
---|---|
29 | |
11 | |
11 | |
10 | |
6 |