Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more
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.
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.
Solved! Go to Solution.
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.
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.
The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!
| User | Count |
|---|---|
| 40 | |
| 36 | |
| 34 | |
| 31 | |
| 27 |
| User | Count |
|---|---|
| 136 | |
| 103 | |
| 66 | |
| 65 | |
| 56 |