Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hallo guys,
Im new to PowerBI and i try to create a simple chart. I got a reference to a excel chart. The problem is that PowerBi always use a calculation to my column. I only want to show values at a specific date.
Here is a Screenshot from my Excel
Thank you for your help!
Best regards
This should work in a standard Line Chart visual in Power BI.
Can you screentshot what you see in Power BI and give a sample of your data?
Thanks
Here is what i see in powerbi. The problem is the sum of the values.. when I remove it powerbi will use another function like count
Here is my data
thank your for your help!
greetings
If you go to the "Modelling" tab of Power BI desktop, and then click on your values column, you should see an option in the middle called "Default Summarization". It usually defaults to sum, but you can change it to "Don't Summarize".
It could be that.
You may need to remove it and add it again for it to work
I tried this but when i use the unsummarized value, power bi automatically doing a calculation like count or sum.
How can i avoid this?
Greetings
Hi @PowerDau,
>>How can i avoid this?
It is impossible to avoid this, current chart only support to use summarized value on value field.
Regards,
Xiaoxin Sheng
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
107 | |
100 | |
80 | |
63 | |
58 |
User | Count |
---|---|
148 | |
111 | |
94 | |
84 | |
67 |