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.
When I select west, it should 11
I have a query. I created a week1_forecast column in ‘A’ table. What it does is, if the region is west, then moves the week_number to +2 and if it is other region it moves week_no to +1.
But, ‘Region’ slicer in the dashboard is from ‘B' table. There is no join b/w 'A' and 'B' tables. I tried to create join but all columns has many to many relation.
Now, how do I make the slicer filter the values in week_forecast column. Can you pls guide?
Here, for example, if i select 'West' then it should show 11 in week1 forecast column.
DAX I wrote:
@Anonymous
Very easy, actually. You create a measure that will return 1 for the rows you want to keep and 0 for the others. Then you use this measure in the Filter Pane of the visual.
Check out the July 2025 Power BI update to learn about new features.
User | Count |
---|---|
23 | |
8 | |
7 | |
6 | |
6 |
User | Count |
---|---|
28 | |
12 | |
10 | |
10 | |
6 |