Join us for an expert-led overview of the tools and concepts you'll need to pass exam PL-300. The first session starts on June 11th. See you there!
Get registeredPower BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.
Hi PBI Community
I'm new to PBI, not very comfortable with advanced DAX measures, hence asking for help. Example show as below,
I want to display the list of values in my new summary report. Data coming from two tables actual (data source - SQL) and budget (excel). I've created a dummy screenshot for better understanding. Please don't follow the values, it is just for explanation purposes.
1. Picture - My final vizualisation metrics
This is the ultimate view i'm looking for
2. Picture of database
Database model
3. This is what I've achieved so far. I've unpivoted the budget data and made some model changes, nothing producing me the final outcome closer to Picture 1. I've created some measures but it is not showing me by week value rather it is summing up, something like this. Again not in an exact format what I'm looking for. The column highlighted in Red is not showing me with the correct figure, maybe my DAX formula needs some tweak. My aim is to attain the yellow figure which gives me the correct value by week
Week to Date Sales DAX Measure = [
Ultimately, my objective is to create a summary report with actual, budget and previous year figures to be filtered by week number displayed next to a week or by the filter. Also Cumulative and Cumulative Variances in different columns a shown in picture 1.
I appreciate your help in assisting me with the custom visualization
Regards
Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
14 | |
10 | |
10 | |
9 | |
9 |
User | Count |
---|---|
20 | |
13 | |
12 | |
11 | |
8 |