Abnormal number display on bar chart

[Anonymous]

Dear Team,

I have computed DAX SAMPERIODLASTYEAR (

CALCULATE(sum(SaleOrderSummary[SaleQtyHL]),SAMEPERIODLASTYEAR('Date'[Date]))). What I faced the abnormal was dispayed on barchart. I would like to seek team supporting to solve this abnormal displaying on bar chart.

Thanks!

LCaynar

[amitchandak]

@Anonymous , Make sure measure is like

CALCULATE(sum(SaleOrderSummary[SaleQtyHL]),SAMEPERIODLASTYEAR('Date'[Date]))

where date table is marked as date table and month on axis is coming from date table

Why Time Intelligence Fails - Powerbi 5 Savior Steps for TI :https://youtu.be/OBf0rjpp5Hw
https://amitchandak.medium.com/power-bi-5-key-points-to-make-time-intelligence-successful-bd52912a5bd4
To get the best of the time intelligence function. Make sure you have a date calendar and it has been marked as the date in model view. Also, join it with the date column of your fact/s. Refer :radacad sqlbi My Video Series Appreciate your Kudos.

[Anonymous]

Hi @amitchandak ,

Thanks your for your prompt supporting. Sure my DAX is correctly. the results was shown on table. But when bring those figure into bar chart. it display abnormal figure in red circle.

Thanks!

[amitchandak]

@Anonymous , From measure tools, Make sure the number format and type is decimal and you have selected 2/3 decimal place as required