Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
Prabha45
Helper III
Helper III

Data Model

Hi All,
I have a table like the below. I need to create a bar chart with Actuals and target. For 2023 I can use 2023 target. But I need to show Q4 2023 and Q1 2024 at a time and the target should  show 50 for Q4 2023 and 25 for Q1 2024.

CategorySub categoryRegionQuarterActualCommentsOwnerTarget 2023Target 2024Target 2025
RoadBikeGlobalQ4-202310WorkingDavid502530
RoadBikeAsiaQ4-20235N/ADavid000
RoadBikeUkQ4-20235 Under validationSmith000
RoadBikeGlobalQ1-202420N/ASmith000
RoadBikeAsiaQ1-202415N/AHenry000
RoadBikeUkQ1-20245WorkingHenry000
ElectronicsLaptopGlobalQ4-202310ManufacturingMicheal15520
ElectronicsLaptopAsiaQ4-20235ManufacturingMicheal000
ElectronicsLaptopUkQ4-20235N/ANeil000
ElectronicsLaptopGlobalQ1-202415workingNeil000
ElectronicsLaptopAsiaQ1-202410N/ANeil000
ElectronicsLaptopUKQ1-20245WorkingNeil000


Thanks in advance.

2 ACCEPTED SOLUTIONS
lbendlin
Super User
Super User

You mention "Data Model"  in the title.  That's exactly what you need.  Your data model needs to have at least three tables - Dates, Actuals, and Targets. Probably more (product hierarchy etc),  but with these three you will be able to accomplish your task.

View solution in original post

v-junyant-msft
Community Support
Community Support

Hi @Prabha45 ,

This part of your data model doesn't make sense and doesn't achieve your desired results under the current data model:

vjunyantmsft_0-1707703980150.png
Please add a table like this:

vjunyantmsft_1-1707704066826.png

Create relationship between two tables:

vjunyantmsft_2-1707704095750.png

The final output is as below:

vjunyantmsft_3-1707704123889.png


Best Regards,
Dino Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

2 REPLIES 2
v-junyant-msft
Community Support
Community Support

Hi @Prabha45 ,

This part of your data model doesn't make sense and doesn't achieve your desired results under the current data model:

vjunyantmsft_0-1707703980150.png
Please add a table like this:

vjunyantmsft_1-1707704066826.png

Create relationship between two tables:

vjunyantmsft_2-1707704095750.png

The final output is as below:

vjunyantmsft_3-1707704123889.png


Best Regards,
Dino Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

lbendlin
Super User
Super User

You mention "Data Model"  in the title.  That's exactly what you need.  Your data model needs to have at least three tables - Dates, Actuals, and Targets. Probably more (product hierarchy etc),  but with these three you will be able to accomplish your task.

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors