Stacked bar chart with % Axis x and numeric data label

[Anonymous]

Hi everyone.

I need support, I have to show a stacked bar chart with X axis as % and the data label should be numeric, having the rest of the bar in grey until 100%, something like this:

This is my model,

Where Reson field is a dimesion tablle with the different type of reason, and the table OrderDetails is my fact table. Show, in the visualization, the field reason of the ClosureReason table is the Axis Y, and the measure is a distinct count of OrderID in the table OrderDetails.

First, I used the visualization 100% stacked bar chart, but it was impossible show the data like the picture, because only show data if exist data related in both table, and I couldn´t add other value like numeric:

Then, used the normal stacked bar chart, but I couldn´t change the X Axis to percent and show the data label like numeric:

Showing the value of the measure like % of grand total=>

I don´t know how could I do it, for now Im using two visualization, one like background using only data of the table reason:

And other inside using the Reason field from the table Reason, and in the axis X  the count of oder from the table OrderDetails:

The problem of this is that the X axis percent is not really correct, does anyone know how to do it on the same object?Thanks

[Icey · Accepted solution]

Hi @Anonymous ,

Try this:

Then, you will get this:

Best Regards,

Icey

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

Thanks a lot!