topic Re: Abnormal number display on bar chart in DAX Commands and Tips

Abnormal number display on bar chart

Anonymous — Tue, 06 Dec 2022 02:48:22 GMT

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

Re: Abnormal number display on bar chart

amitchandak — Tue, 06 Dec 2022 03:30:01 GMT

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.

Re: Abnormal number display on bar chart

Anonymous — Tue, 06 Dec 2022 03:41:37 GMT

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!

Re: Abnormal number display on bar chart

amitchandak — Tue, 06 Dec 2022 03:42:24 GMT

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