Forum Discussion
Falsche Werte im Visual
Hallo!
In einer Tabelle habe ich Messwerte, die ich in einem Liniendiagramm darstellen will. x-Achse=Datum, y-Achse=Werte.
Leider zeigt es mir falsche Werte an, bzw. sind die Werte höher als in der zugrundeliegenden Tabelle selbst.
In der Tabelle ist bei der Werte-Spalte"Zusammenfasung" auf "Nicht zusammenfassen" eingestellt.
Hat jemand eine Idee dazu?
Danke
LG
Norbert
Hi, Spurgeon74
I create a sample table:
Check your date hierarchy, Power BI typically uses date hierarchies by default. Make sure you're using the actual date field and not the date hierarchy. You can change this setting by clicking the drop-down arrow next to the date field in the Axis section and selecting Date instead of Date Hierarchy.
You can also verify that the data is sorted in the correct order. You can do this by clicking on the ellipsis in the top right corner of the chart ... and specify the field and order to sort by to adjust the sort order. You can check the following post:
Solved: Incorrect values in Y axis (line chart) - Microsoft Fabric Community
How to Get Your Question Answered Quickly
Best Regards
Yongkang Hua
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
2 Replies
Bitte beachten: Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
Do not include sensitive information or anything not related to the issue or question.
If you are unsure how to upload data please refer to https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216
Please show the expected outcome based on the sample data you provided.
Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523Hi, Spurgeon74
I create a sample table:
Check your date hierarchy, Power BI typically uses date hierarchies by default. Make sure you're using the actual date field and not the date hierarchy. You can change this setting by clicking the drop-down arrow next to the date field in the Axis section and selecting Date instead of Date Hierarchy.
You can also verify that the data is sorted in the correct order. You can do this by clicking on the ellipsis in the top right corner of the chart ... and specify the field and order to sort by to adjust the sort order. You can check the following post:
Solved: Incorrect values in Y axis (line chart) - Microsoft Fabric Community
How to Get Your Question Answered Quickly
Best Regards
Yongkang Hua
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
