Can a column be nested inside it's "parent" column in a visual?

[carlosDash]

I have two columns: "All Customers" and "Customers New". "All Customers" consists of old customers and new customers. Can I display the "Customers New" column nested inside the "All Customers" in a stacked column visual (or any other for that matter)?

I've attached an illustration on what I want to do:

 

[Anonymous]

Hi @carlosDash

You can display two or more values with a stacked column chart.

[carlosDash]

Hi @Anonymous,

I know, but as the name states, it's "stacked", not "nested". The "Customers New" is actually contained within "Customers All", not a separate entity. Creating a stacked column would display the total value incorrectly. 

[v-ljerr-msft · Accepted solution]

Hi @carlosDash,

In this scenario, I would suggest you create a new measure/column for "Customers Old" first, then show "Customers New" and "Customers Old" on the stacked column chart. The formula to create the new measure/column should be similar like below.

Customers Old = [Customers All] - [Customers New]

Regards

[carlosDash]

Hi @v-ljerr-msft

Yeah, I guess this is the best solution to this problem. I was just hoping to avoid another calculated column 

Thanks!