Forum Discussion
Multiple Stacked Small Visuals based on years and region
Hello PowerBI Users,
I am aiming to replicated in powerbi small visuals below.
Each visual is based on a region, each column is a year, and for each year 3 meaures are stacked
Hi youngja_66
We have this option with a stacked column chart << multiples :In your scenario you need to put :
The region as "small multiples"
Year on X-axis
and measures on Y-axis
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly
5 Replies
- Ritaf1983
Super User
Hi youngja_66
We have this option with a stacked column chart << multiples :In your scenario you need to put :
The region as "small multiples"
Year on X-axis
and measures on Y-axis
If this post helps, then please consider Accepting it as the solution to help the other members find it more quicklyThe measure for some of the years eg. 2007, 2013, 2017, 2020 are within the fact table, but year measures in between are calculated e.g. 2008 = 2007 + (2013-2007) * 1/6 .
2007,2013,2017,2020 measure is dervied directly from the fact table
e.g. 2008
If i put the x axis as 'year' very odd output
I'm thinking I am going to have to use DAX to create a pivot table similar to this where I can calc the meaures for the in between years?
- Ritaf1983
Hi youngja_66
Unfortunately, I can't understand the problems of the model from the pictures.
Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
https://community.powerbi.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-...
Please show the expected outcome based on the sample data you provided.
https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523
Thank you for your response!
