Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
98 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
100 | |
86 | |
64 |