Forum Discussion

gerardoalvarado's avatar
gerardoalvarado
New Member
9 years ago

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

I have 2 data tables (calendar and data) with a working relationship through the field "Mes" (month)   When shown in the visual "table" you can see how data changes each month. When changing to oth...
Need Help
Phil_Seamark's avatar
Phil_Seamark
Icon for Microsoft Employee rankMicrosoft Employee
9 years ago

In your image, Do Mes and 5-PPMproceso-Meta come from the same table?  I'm guesing not.

 

If they come from different tables, do you have a relationship setup between the two tables?

gerardoalvarado's avatar
gerardoalvarado
New Member
9 years ago

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)

 

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. 

I worked with the same visual in previous versions of PBI and this didn't happen.

  • v-ljerr-msft's avatar
    v-ljerr-msft
    Icon for Microsoft Employee rankMicrosoft Employee
    9 years ago

    Hi gerardoalvarado,

     

    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))

     

    To further investigate on this issue, could you share a sample pbix file which can reproduce the issue? You can upload it to OneDrive or Dropbox and post the link here. Do mask sensitive data before uploading.:smileyhappy:

     

    Regards