Reply
Prabha45
Helper III
Helper III
Partially syndicated - Outbound

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

Syndicated - Outbound

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

Syndicated - Outbound

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

Syndicated - Outbound

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

Syndicated - Outbound

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.

avatar user

Helpful resources

Announcements
March PBI video - carousel

Power BI Monthly Update - March 2025

Check out the March 2025 Power BI update to learn about new features.

March2025 Carousel

Fabric Community Update - March 2025

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

Top Solution Authors (Last Month)
Top Kudoed Authors (Last Month)