Forum Discussion
inconsistent display on area chart
Hi
I have a table of groups of items, items and a monthly plan production.
In this table unpivoted monthly plan production and created a measure to get total by year.
In a table I can see total plan production by group, in an area chart also I can see how total production growing in time (I´m using the same measure) but when I select any group the area chart show the total production and not the production in time of group I've selected.
Can you tell me what I'm doing wrong and how to solve it.
Thanks
4 Replies
- MFelix
Super User
Hi GustavoV1 ,
The groups in the table visualization are being picked up from what table the same one? Is there any dimension tables or relationship between other tables? what is the measure you are using?
If you look at the images below as you can see when I change the group the area chart changes:
Hi MFelix
These are some of my tables and its relations
Tables:
Table 1 has dimensions, primary key (work ID#)
Table 2 has monthly plan, storage in mensual M,
Table 3 is an auxiliary table to sort field "Cartera" of table 1 different from alphabetic sort.
Besides I created a measure called "Anual" = sum (tblMensualesPO[Mensual M])" this is the measure I've been using with Periodo (date field) in area chart to show how will be a production by "Cartera" along of year but doesn't work ☹️
Can you give any clue to solve it??
- MFelix
Hi GustavoV1 ,
In the attach PBIX I have made a small mockup, this is not exactly you model but believe the realtionships are matching.
As you can see it's working properly, can you check to see if there is any other changes that I cannot see on your image that may influence, be aware that the use of column from one table instead of another causes the interactions or measure results to work incorrectly or not at all.
