Forum Discussion
MTD YTD issue on histogram
Hey guys, i am really struggling with this right now, hope you can help me. Basically, I finally got the right numbers using MTD and YTD for my calculations but now I need to display them on the histogram, but I need them to be split up on histogram like three seperate measures, just like shown below. However, This is what I get right now. And everytime i take off date hierarchy or do something else, then the MTD function doesnt work.
Hi Anonymous ,
According to my understand , you want to set measure name as X-axis, right?
You could create a new table like this:
And then use SWITCH() function to match each measure:
Measure = SWITCH ( MAX ( 'For X-axis'[Type] ), "YTD", [YTD], "MTD", [MTD] )Then you could "seperate" measures in visual:
Did I answer your question ? Please mark my reply as solution. Thank you very much.
If not, please upload some insensitive data samples and expected output.Best Regards,
Eyelyn Qin
3 Replies
Hi Anonymous ,
According to my understand , you want to set measure name as X-axis, right?
You could create a new table like this:
And then use SWITCH() function to match each measure:
Measure = SWITCH ( MAX ( 'For X-axis'[Type] ), "YTD", [YTD], "MTD", [MTD] )Then you could "seperate" measures in visual:
Did I answer your question ? Please mark my reply as solution. Thank you very much.
If not, please upload some insensitive data samples and expected output.Best Regards,
Eyelyn Qin