cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
gadgetman4u Frequent Visitor
Frequent Visitor

Why Power BI visualization shows constant line graph of sum when table values are different

I can't seem to figure out why my Power BI visualization for 3 tables, has two of the tables showing as constant lines, when the values in those tables are different and not constant values.

I thought Power BI was doing some type of conversion or formatting but it seems not to be the case. The other 2 tables that I have are done in the same way as the first table.  It seems that this constant value is the sum of all the values in my table.  I've noticed that for my column, the property shows as a sum, but for the first table, it also shows as a sum but does not sum the values in that table.

 

Any ideas why?

 

Thanks.

 

1 ACCEPTED SOLUTION

Accepted Solutions
v-ljerr-msft Super Contributor
Super Contributor

Re: Why Power BI visualization shows constant line graph of sum when table values are different

Hi @gadgetman4u,

 

In your scenario, I would suggest you to merge the 3 tables into a single table with the Merge Queries option in Query Editor first, then it should work as expected. For more details about how to use Merge Queries option in Power BI Desktop, you can refer to this article.

 

In addition, understanding relationships and filter propagation is important to build reports with Power BI Desktop as Matt mentioned above. The following article is for  your referenceSmiley Happy

Create and manage relationships in Power BI Desktop

 

Regards

6 REPLIES 6
Super User
Super User

Re: Why Power BI visualization shows constant line graph of sum when table values are different

have you joined the tables?  Do you have a lookup table and data tables?  you need to understand relationships and filter propagation before you can understand how it works.  here is some reading for you.

http://exceleratorbi.com.au/the-optimal-shape-for-power-pivot-data/

 

 

 

* Matt is a Microsoft MVP (Power BI) and author of the Power BI Book Supercharge Power BI.
gadgetman4u Frequent Visitor
Frequent Visitor

Re: Why Power BI visualization shows constant line graph of sum when table values are different

I just have a regular table where my SQL script writes to this table.  I don't have any lookup tables or any other tables.  It looks like it is taking the sum of all the values in the column of the table, but I can't see in the Power BI Desktop query properties where I have that selected.  

 

I even tried to create another Power BI Desktop file and read this table, and it also is showing the sum of all the values in the column of the table.

 

Any ideas on how to solve?

 

Thanks.

Super User
Super User

Re: Why Power BI visualization shows constant line graph of sum when table values are different

You probably need to describe your table structure a bit more. Or better yet, post a screens hot if you can.

What column are you dragging to the axis?

To learn more about DAX visit : aka.ms/practicalDAX

Proud to be a Datanaut!

gadgetman4u Frequent Visitor
Frequent Visitor

Re: Why Power BI visualization shows constant line graph of sum when table values are different

I have 3 tables, table1, table2, and table3.  I want to visualize the num_users for each table together on a line graph.  The first screenshot shows what happens when I visualize the data.  You can see that num_users_1 from table2 is correct, but num_users_3 and num_users_2 from table3 and table1 respectively, are constant values.  From  the second screenshot, if I select the day and the num_users for the visualization to be another table, then that table will show properly, but adding the other tables will also be constant values.  In fact, these constant values are exactly the sum of the values in that column.  

 

I have also attached screenshots showing the data in the 3  tables.  

 

What is happening that causes this visualization to behave in this manner?

 

Thanks.Sum values.JPGSum values2.JPGtable1.JPGtable2.JPGtable3.JPG

v-ljerr-msft Super Contributor
Super Contributor

Re: Why Power BI visualization shows constant line graph of sum when table values are different

Hi @gadgetman4u,

 

In your scenario, I would suggest you to merge the 3 tables into a single table with the Merge Queries option in Query Editor first, then it should work as expected. For more details about how to use Merge Queries option in Power BI Desktop, you can refer to this article.

 

In addition, understanding relationships and filter propagation is important to build reports with Power BI Desktop as Matt mentioned above. The following article is for  your referenceSmiley Happy

Create and manage relationships in Power BI Desktop

 

Regards

gadgetman4u Frequent Visitor
Frequent Visitor

Re: Why Power BI visualization shows constant line graph of sum when table values are different

Thanks.  This worked.