Summarization in graphic visuals not using relationships created, Table visual OK

Question

I have 2 data tables&nbsp;(calendar and data) with a working relationship through the field "Mes" (month)&nbsp;When shown in the visual "table" you can see how data changes each month. When changing to other type of visual (KPI; Bar, Line, etc..) the data is summarized and the same result is shown in every month. There is no option "don´t summarize" for values in visual. It appears like&nbsp;the relationship "month" is not working for data (works ok with measures)&nbsp;I use PBI Desktop version&nbsp;2.43.4647.541 , this didn´t happen in previous versions.&nbsp;Is this a bug or am I doing something wrong?

vvelarde · Answer

gerardoalvarado&nbsp;Hi, please Post sample data to quickly replicate your case.&nbsp;Thanks

gerardoalvarado · Answer

Hi Victor!This is the table constructed from 2 different data sets, related by the column "Mes"&nbsp;When changing the visual to Column chart, the values gets summarized, with no option for "dont summarize"

phil_seamark · Answer

In your image, Do Mes and 5-PPMproceso-Meta come from the same table? &nbsp;I'm guesing not.&nbsp;If they come from different tables, do you have a relationship setup between the two tables?

gerardoalvarado · Answer

Hi Phil!Yes, they come from 2 different tables. Relationship is set up with column "mes"(month), and works OK in the Table Visual. (you can see how data changes each month)&nbsp;The problem is when I change the visual type, PBI is summarizing all the data, and showing this total result in every month, instead of summarizing each month by itself and showing that.&nbsp;I worked with the same visual in previous versions of PBI and this didn't happen.

v-ljerr-msft · Answer

Hi&nbsp;gerardoalvarado,
&nbsp;
According to your description above, I have tested it on my environment. And the relationship works all fine without the issue above. I'm also using the latest version of Power BI Desktop.(2.43.4647.541 64-bit (February 2017))
&nbsp;
To further investigate on this issue, could you share a sample pbix file which can reproduce the issue?&nbsp;You can upload it to OneDrive or Dropbox and post&nbsp;the link here. Do mask sensitive data before uploading.:smileyhappy:
&nbsp;
Regards

Forum Discussion

Summarization in graphic visuals not using relationships created, Table visual OK

5 Replies

Related content

Creating relationships

Relationship

Create relationship dialog box

Parameter in summarize

Relationship Issue