topic Re: Problem with visual plot (Dax Query) in DAX Commands and Tips

Problem with visual plot (Dax Query)

adii — Thu, 14 Mar 2024 12:02:31 GMT

Hello , I have problem with visual , I don't understand why visual shows a wrong .. . In Dad query total is correct, but I couldn't plot graph.

On photo I show my dax query and windows with wrong information

Pls help

lbendlin — Fri, 15 Mar 2024 01:20:24 GMT

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/1447523

Anonymous — Fri, 15 Mar 2024 06:12:22 GMT

Hi adii ,

To troubleshoot this, consider the following steps:

Review the Date Function Usage: Ensure that the function in your DAX query is receiving the correct year, month, and day arguments. The function syntax should be DATE function (DAX) - DAX | Microsoft Learn . Each argument must be an integer, and the resulting date must be within the acceptable date range for Power BI.
Check Data Types: Verify that the columns or values you're using as arguments for the function are of the correct data type (i.e., integers for year, month, and day). If you're deriving these values from other columns, ensure those columns are correctly formatted or cast them to integers using the or functions.
Validate Date Range: Ensure that the date being generated by the function falls within a valid range. Power BI can handle dates from January 1, 1900, to December 31, 9999. If your calculation might result in dates outside this range, you'll need to adjust your logic.

You can try changing the measure:

... selected_end_month= EDATE(_las_date,-1) ...

Best Regards,

Neeko Tang

If this post  helps, then please consider Accept it as the solution  to help the other members find it more quickly.