inconsistent display on area chart

[GustavoV1]

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

 

[MFelix]

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:

[GustavoV1]

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.

[GustavoV1]

@MFelix Thanks for your answer

I used a version of powerBI earlier than yours so I can´t read your pbix.

my company don't let us update PowerBI, it would be possible you publish this pbix in an earlier version??

My version is

One more time, thanks by your time