Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.
Hi, I'm hoping someone can help me with how to do this. I have a table that looks like this...
date | region | attribute | value |
1/07/2023 | GAR | target_2023 | 78 |
1/07/2023 | YXR | target_2023 | 29 |
1/07/2023 | BMR | target_2023 | 78 |
1/07/2023 | GAR | actual_2023 | 82 |
1/07/2023 | YXR | actual_2023 | 31 |
1/07/2023 | BMR | actual_2023 | 82 |
1/07/2024 | GAR | target_2024 | 166 |
1/07/2024 | YXR | target_2024 | 54 |
1/07/2024 | BMR | target_2024 | 180 |
1/07/2024 | GAR | actual_2024 | 82 |
1/07/2024 | YXR | actual_2024 | 31 |
1/07/2024 | BMR | actual_2024 | 82 |
1/07/2025 | GAR | target_2025 | 248 |
1/07/2025 | YXR | target_2025 | 81 |
1/07/2025 | BMR | target_2025 | 271 |
1/07/2026 | GAR | target_2026 | 290 |
1/07/2026 | YXR | target_2026 | 95 |
1/07/2026 | BMR | target_2026 | 315 |
1/07/2027 | GAR | target_2027 | 310 |
1/07/2027 | YXR | target_2027 | 101 |
1/07/2027 | BMR | target_2027 | 338 |
The outcome I'm hoping for is a line and clustered column chart, where the line values are the summed if the attribute column contains "target" (Line y-axis) and the bars are summed if it contains "actual" (Column y-axis).
I will use a slicer that will filter this finished chart by region.
Thanks 🙂
Solved! Go to Solution.
This is the source data
Split column by "_" delimiter
Renaming the columns
Created mesures for Actual and Target
Final output with target in line and actual in column and x axis (date) formatted in Categorical.
Did you select line and clustered column chart from the visual
Also create the mesures as shown the prior snapshots.
Oh hang on, I forgot to change one thing in my original data. It's working now ... thanks so much!
Yes I did, that exact visual
This is the source data
Split column by "_" delimiter
Renaming the columns
Created mesures for Actual and Target
Final output with target in line and actual in column and x axis (date) formatted in Categorical.
Hi Rakesh1705, thanks, I followed your screenshots and created the measures but I still can't seem to get the "actual" values (bars) on my chart, including formatting as Categorical. Any ideas?
Hi Irwan, thanks for getting back to me. I applied your DAX to my real data and I get the line for the "target" values but no bar for the "actual" values. I have set the x and y axis as per your screenshot. Any ideas what might be wrong? And sorry, the data I provided for "actual_2024" attributes were a copy and paste and I forgot to change these figures to something different.
Hello @onedayover
please check if this can accomodate your need.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.
User | Count |
---|---|
21 | |
15 | |
14 | |
11 | |
7 |
User | Count |
---|---|
26 | |
24 | |
12 | |
11 | |
10 |