Hi sir Dane hope you’re doing well. I just want to ask if this is also applicable with 2 measures in y-axis. Like for example I have a [Total Revenue] and [Total Profit] ?
@@Ninjhaw you need to change the viz to clustered column for multiple measures involved. Whether we like it or not, that is how stacked column charts behave when there are two visible measures at a time in a category.
What I did po is I created another column chart and I place it behind my actual chart. Para mag ha highlight nlng po yung background nung visual for selected month but I think it is not easily maintanable for me
Hi sir Dane hope you’re doing well. I just want to ask if this is also applicable with 2 measures in y-axis. Like for example I have a [Total Revenue] and [Total Profit] ?
@@Ninjhaw yes, that's equivalent to four measures
@@DAXJutsu Nice. will try this method sir. Thank you sir Dane
@@DAXJutsu the problem is the other pair of selected and non selected measure will go above the other bars since it's a stacked column chart.
@@Ninjhaw you need to change the viz to clustered column for multiple measures involved. Whether we like it or not, that is how stacked column charts behave when there are two visible measures at a time in a category.
What I did po is I created another column chart and I place it behind my actual chart. Para mag ha highlight nlng po yung background nung visual for selected month but I think it is not easily maintanable for me