cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Power_BI_Help
Helper I
Helper I

Linechart: Unable to "Not Sum" Data | Data Summarization Do Not Calculate Not Working

Hey, I'm new to power BI and having difficulties showing a simple X Y chart. I linked a table from excel containing a table with a date (formatted as a date) and drawdown column (formatted as a number). Within the power query tab in Power BI the data format is decimal for this column. When adding a bar chart I have selected "Do not Calculate" however the chart still defaults to a summarization value. I am unable to turn this off. Is there a way to display data that does not have a calculation applied to it?

 

I would like this to display the Drawdown by Year.

 

Ref: https://imgur.com/a/XONSE3V

1 ACCEPTED SOLUTION
amitchandak
Super User IV
Super User IV

The line chart will not allow you un-summarized measure.

But Have tried using date Hierarchy by not removing the Qtr, Month and Day. And view at the year level.  And view at the year level and then drill down.



Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Dashboard of My Blogs !! YouTube Channel !! Connect on Linkedin

Proud to be a Super User!

View solution in original post

4 REPLIES 4
amitchandak
Super User IV
Super User IV

The line chart will not allow you un-summarized measure.

But Have tried using date Hierarchy by not removing the Qtr, Month and Day. And view at the year level.  And view at the year level and then drill down.



Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Dashboard of My Blogs !! YouTube Channel !! Connect on Linkedin

Proud to be a Super User!

View solution in original post

Not being able to do it was the answer I was looking for. 

 

I ended up using a "minimum" for this solution. In continuing to explore the dashboarding over the weekend I have realized that the structure of DAX formulas are different than I would have calculated things in Excel. This will continue to be a learning experience. 

 

Thanks for all the responses.

Greg_Deckler
Super User IV
Super User IV

Not in a line chart like that. What would you do if you had two or more data points for the same line on a line chart. How are you going to display all of them if you do not aggregate? If you do not aggregate, what is the value of that line for that day? 


---------------------------------------

@ me in replies or I'll lose your thread!!!

I have a NEW book! 
DAX Cookbook from Packt
Over 120 DAX Recipes!




Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




Ashish_Mathur
Super User III
Super User III

Hi,

I am not clear about what you want.  In a simple table, show the expected result.  Also, share the link from where i can download your PBI file.


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/

Helpful resources

Announcements
PBI_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

Get Ready for Power BI Dev Camp

Microsoft named a Leader in The Forrester Wave

Microsoft received the highest score of any vendor in both the strategy and current offering categories.

Get Ready for Power BI Dev Camp

Power BI Dev Camp - September 30th, 2021

Mark your calendars and join us for our next Power BI Dev Camp!

PowerPlatform 768x460.png

Microsoft Learn

Check out our new Discover Your Career Path blog post series and get all the details.

Top Solution Authors