Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Need help with Line & Clustered Column Chart

Hi Everyone, I'm relatively new to the BI platform and was hoping to get some help with a project I am working on. I can't disclose a lot of detail but will try to provide enough information to hope...
Need Help
Tips and Tricks
Tutorial Requests
  • samdthompson's avatar
    samdthompson
    4 years ago

    Hello, I have some similar stuff I have to do around pricing. To tackle it i use two measures:

     

    CustomerPrice = SUM(DataTable,DataTable[Price])

    ComparisonPrice = CALCULATE([CustomerPrice], ALL(DataTable]))

     

    I can then show the customers on the bars and the comparison as a line. You may want to be more nuanced about the comparison line ie you do want to vary regionally or some such. In that case it might be something like:

     

    ComparisonPrice =

    CALCULATE([CustomerPrice],FILTER(ALL(Customer),Customer[Region]=SELECTEDVALUE(Customer[Region]))).
     
    Hope this points you in the right direction anyway.
     
     
samdthompson's avatar
samdthompson
Memorable Member
4 years ago

Hello, I have some similar stuff I have to do around pricing. To tackle it i use two measures:

 

CustomerPrice = SUM(DataTable,DataTable[Price])

ComparisonPrice = CALCULATE([CustomerPrice], ALL(DataTable]))

 

I can then show the customers on the bars and the comparison as a line. You may want to be more nuanced about the comparison line ie you do want to vary regionally or some such. In that case it might be something like:

 

ComparisonPrice =

CALCULATE([CustomerPrice],FILTER(ALL(Customer),Customer[Region]=SELECTEDVALUE(Customer[Region]))).
 
Hope this points you in the right direction anyway.
 
 
Anonymous's avatar
Anonymous
Not applicable
4 years ago

I've followed up on your tips to use the Calculate function and I can now show an aggregate average that is not affected by a customer slicer as long as I keep that average on a separate visual. However, once I combine the average along with the customer specific data onto the same chart (clustered column and line) then the customer filter affects the aggregate measure. I can't figure out how to get these two pieces of info on the same chart. Any other thoughts?