Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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:
Solved! Go to 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
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.
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
Yeah, I guess this is the best solution to this problem. I was just hoping to avoid another calculated column
Thanks!
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
64 |
User | Count |
---|---|
135 | |
122 | |
101 | |
71 | |
61 |