Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Compete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.

Reply
sulen
Regular Visitor

How to display actual values in line chart without aggretion it

Hi,

 

I want to show top ten values in line column chart. But when i put my data in y axis line cumilative chart has sum,average,count etc. options and not displaying the actual data. I have several text datas (some of them are duplice) and the values are refered to the texts.

 

Can you help me how can i display the actual values for the data that i put in the x axis?

sulen_0-1695667497732.png

 

1 ACCEPTED SOLUTION

I solved the problem by choosing maximum option. However I have a new problem now. So basically im tyring to create target area. And then highlight th values outside of the target.So i create new measure for highligting but inside of the measure, in dax formula i can't define column where i get my data. I am attaching the photos of dax formula and the visual table. I want to define Ticket Close days column.

 

sulen_1-1695989178730.png

sulen_2-1695989214812.png

 

 

View solution in original post

2 REPLIES 2
ChiragGarg2512
Solution Sage
Solution Sage

@sulen, click on the column in table pane, this will open the column tools. Change the function to don't summarize. If that doesn't work provide more description on the text part of your problem.

I solved the problem by choosing maximum option. However I have a new problem now. So basically im tyring to create target area. And then highlight th values outside of the target.So i create new measure for highligting but inside of the measure, in dax formula i can't define column where i get my data. I am attaching the photos of dax formula and the visual table. I want to define Ticket Close days column.

 

sulen_1-1695989178730.png

sulen_2-1695989214812.png

 

 

Helpful resources

Announcements
July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

Find out what's new and trending in the Fabric community.

Top Solution Authors