total vs. month on month transacted.

[Anonymous]

Hi Friends,

I want to show Total Distributors vs. Month on Month transacted in the chart. Please help me how can I do this ?

Current Chart:

Expected Chart:

[v-eqin-msft]

Hi @Anonymous ,

Maybe you could use Waterfall chart like this:

Did I answer your question ? Please mark my reply as solution. Thank you very much.

If not, please upload some insensitive data samples and expected output.

Best Regards,

Eyelyn Qin

[Greg_Deckler]

@Anonymous You would have to create a disconnected table for your x-axis and then a suitable measure. Use the Disconnected Table Trick as this article demonstrates: https://community.powerbi.com/t5/Community-Blog/Solving-Attendance-with-the-Disconnected-Table-Trick/ba-p/279563

Hard to be more specific. Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

The most important parts are:
1. Sample data as text, use the table tool in the editing bar
2. Expected output from sample data
3. Explanation in words of how to get from 1. to 2.

[Anonymous]

Hi @Greg_Deckler ,

Thanks for sending quick help and solution but still I am not able to implement in my chart.

Could you please elaborate more using my example ? It will be great help from your side.

Thanks a lot in advance.

[Greg_Deckler]

@Anonymous - Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

The most important parts are:
1. Sample data as text, use the table tool in the editing bar
2. Expected output from sample data
3. Explanation in words of how to get from 1. to 2.