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

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more

Reply
Anonymous
Not applicable

Data Representation

Hi guys, I am having a small trouble here with Power Bi functionality. 
I have looked for an answer, I did what was said, but no change still.


I have a sample data that includes data for several years. What I want to do with that, is to represent it in the graph with the actual year, month, day (timestamp) and value "not sum count or any other", just value. I found out that I can change the settings under modeling tab. I have changed it but no luck. And it shows sum of the count column on the graph as visible, which I am trying to prevent, as I need value to be displayed.
Instead of showing it all on one graph I have to jump around the graph to find one value I am looking for, which is not comfortable. 
I will attach an image to represent of what I have at the moment. But it is not what I am looking for.

 

SCREENSHOT


On that screenshot i would like to see full dates and its values. Is there anyone that could give me some feedback on that ? 


PS: If required info. I have two tables, one consists of date, ID, cluster_id, count and second is ID, from, to, date, user_id, etc.


In explanation above I am using ONLY date & count from table 1. Just like visible in screenshot below.
SCREENSHOT2


Thanks in advance for your help.

1 ACCEPTED SOLUTION
rocky09
Solution Sage
Solution Sage

You can do the following

 

1. You can select the small down arrow, so you can get out from hirarchy. So, you can see all dates on the graphs.

or

2. You can use Drill through options to go through the levels such as Year --> Quarter --> Month --> Date. So, you can play with the hirarachy by removing Quarter, Month, year from the Date Field.

 

deleteme

 

View solution in original post

1 REPLY 1
rocky09
Solution Sage
Solution Sage

You can do the following

 

1. You can select the small down arrow, so you can get out from hirarchy. So, you can see all dates on the graphs.

or

2. You can use Drill through options to go through the levels such as Year --> Quarter --> Month --> Date. So, you can play with the hirarachy by removing Quarter, Month, year from the Date Field.

 

deleteme

 

Helpful resources

Announcements
Power BI DataViz World Championships

Power BI Dataviz World Championships

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!

December 2025 Power BI Update Carousel

Power BI Monthly Update - December 2025

Check out the December 2025 Power BI Holiday Recap!

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.