Bar chart showing in different lines rather than a single line

[PBI5851]

Hello,

I am trying to display a sum of calls on a graph but rather than summarizing it, the graph shows the data in two lines. please can you tell me how to get the data as a single line of 6 and change accordingly when i move the slicer. 

Raw data 

Studentid	CreatedDate	CallType	CountofContacts
AB123	01/08/25	Direct	4
AB123	12/24/24	Direct	3
AB123	12/20/24	Direct	3
AB123	12/16/24	Direct	3
AB123	01/02/25	Direct	2
AB123	01/13/25	Internet Search	1
AB123	07/18/24	Indirect	1
AB123	11/25/24	Direct	1
AB123	07/18/24	Direct	1
AB123	07/15/24	Direct	1
AB123	08/07/24	Direct	1

This is my setup, 

since its the X axis, its showing the different values, is it possible to show a single value of 6 rather than 4 and 2. So, if I change the date range to 11/22/24 to 1/31/25, the count is 16 , but i get 4 bars. 

Thank you. 

[danextian · Accepted solution]

Hi @PBI5851 

I’m assuming you're referring to columns or bars, not lines. When you use the count as a dimension, the value is still being summarized but the summary is broken down by each unique count value. To address this, calculate the filtered sum of count per Account ID and store the result in a disconnected table that contains the possible count values.

Disconnected count table

Counts = 
GENERATESERIES ( 0, 100, 1 )

Measure

Count of Contacts Grouped = 
SUMX (
    FILTER (
        SUMMARIZECOLUMNS (
            'Table'[Studentid],
            "@count", CALCULATE ( SUM ( 'Table'[CountofContacts] ) )
        ),
        [@count] IN VALUES ( Counts[Value] )
    ),
    [@count]
)

Result

Please see the attached sample pbix.

[V-yubandi-msft]

Hi @PBI5851 ,

May I ask if you have resolved this issue? If so, please mark the helpful reply and accept it as the solution. This will be helpful for other community members who have similar problems to solve it faster.

 

Thank you.

[V-yubandi-msft]

Hi @PBI5851 ,

I hope this information is helpful. Please let me know if you have any further questions or if you'd like to discuss this further. If this answers your question, please Accept it as a solution and give it a 'Kudos' so others can find it easily.

Thank you.

[V-yubandi-msft]

Hi @PBI5851 ,

I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions. If my response has addressed your query, please accept it as a solution and give a 'Kudos' so other members can easily find it.

Thank you.

[V-yubandi-msft · Accepted solution]

Hi @PBI5851 ,

Thank you for your feedback. I noticed that the Y axis is currently displaying the count of contacts grouped by value instead of showing  1 per Student ID. This happens because Power BI automatically aggregates data based on the selected fields, leading to the count being split rather than maintaining a fixed value for each Student ID.

To better align with your requirement, i  can adjust the measure and visual settings so that the X axis correctly represents Student ID while ensuring the Y axis reflects the total count properly. Could you review the attached screenshot and let me know if this meets your expectations? If any further refinements are needed, please let me know.

FYI:

Regrads,

Yugandhar.

[danextian · Accepted solution]

Hi @PBI5851 

I’m assuming you're referring to columns or bars, not lines. When you use the count as a dimension, the value is still being summarized but the summary is broken down by each unique count value. To address this, calculate the filtered sum of count per Account ID and store the result in a disconnected table that contains the possible count values.

Disconnected count table

Counts = 
GENERATESERIES ( 0, 100, 1 )

Measure

Count of Contacts Grouped = 
SUMX (
    FILTER (
        SUMMARIZECOLUMNS (
            'Table'[Studentid],
            "@count", CALCULATE ( SUM ( 'Table'[CountofContacts] ) )
        ),
        [@count] IN VALUES ( Counts[Value] )
    ),
    [@count]
)

Result

Please see the attached sample pbix.

[PBI5851]

@danextian Thank you for the response. but there is an issue. The Y axis is the count of student id, which in this case will be 1. But as per your pbix, it is plotting count of contacts grouped with value .