Help with Data visualization, pretty please

[george_o0802]

I would like to convert the attached chart to a %. I cannot use the simple % of Grand total function as it gives me each bar as a % of the grand total such that the entire data set adds up to 100%. What I need is the latest data to add up to 100% and the previous data to add up to 100%. E.g., the latest medium data should be around 25.4% and the previous medium should be around 27.8%.

[HarishKM]

@george_o0802  Hello,
Can you more detail about your requirement?

Or  you can try similer formula below.

Total sales % =

Var _sales = SUM(financials[Gross Sales])

Var _totalsales = CALCULATE(SUM(financials[Gross Sales]),ALL(financials))

Return

DIVIDE(_sales,_totalsales)

Thanks
Harish M

[george_o0802]

In short,
I want to present this data as a %. This is a product and this is affluence data for customers of said product in the latest time period and previous time period. I have been given the data as a raw customer number but I would like to convert this to a %. I want this chart to show what % of each period customers were in each affluence demographic group. For example, the latest period has 134k customers and 20k of those were very low affluence. I want this to be shown as a % (14.93%). For the previous period, there were 115k customers 17k of which were very low affluence and I would like this as a % of the previous period (14.78%). Thereby showing any changes in prevalence of affluence demographics.

Does this help at all?