topic Re: Custom coloumn in DAX Commands and Tips

Custom coloumn

Narenthir — Wed, 22 Feb 2023 01:43:33 GMT

If i combined the 2 cloumns then my values are wrong in the bar chart. But its shows correct value if changed to table.Help needed, Thanks in advance.

Re: Custom coloumn

amitchandak — Wed, 22 Feb 2023 03:16:12 GMT

Narenthir , if you are using the stacked total option, then it will sum up. While the table total is recalculated. I doubt you are using some row context.

Try to use a line with 0 width to show the label (Combo Viusal)

https://medium.com/@amitchandak/power-bi-when-total-label-on-stacked-visual-is-not-sufficient-72e5de0d0809

Re: Custom coloumn

Narenthir — Wed, 22 Feb 2023 07:08:19 GMT

Hi Amit, Thank for the reply,
I will give a little backround. My excel data consist of 3 to 4 text columns and 8 Qtr(2years) colums. I do some query format change and look like this

After this apply and load. And i created running total measure for the value. And concatenate 2 colums(fab and Position) If plot the chart with seperate charts with legend like (fab , hub, position) it works fine.

When i used my concatenate coloumn(Fab & Position) the value dosent match

I hope will get solution thanks.