Create a line chart visuals that track %

[mike_newbs]

Hello

Our business sends leads to business partners across the country who use them to sell products.

The leads have to be accepted by the partner. There are three different acceptance rates:

• Accepted = Partner has accepted it
• Waiting to be accepted = Lead is with a partner and they have 24 hours to accept it
• Not accepted = Lead was not accepted by the partner

I created a graph in Excel that tracks the Acceptance Rates, split by product and month.

The data I use is basically:

Lead created	Product	Acceptance status
Apr	Product 1	Accepted
Apr	Product 1	Accepted
May	Product 1	Waiting to be accepted
May	Product 2	Not accepted
Jun	Product 3	Not accepted

The graph in Excel shows the % of leads (split by month and product) accepted. Most cases this is over 90%

How can I do this in Power Bi?

Also is it possible to avoid using the "Group by" function? Each lead has its own ID that is linked to other visuals. Ideally I would like to keep the ID because if a user filters by product on a sliver in the report, it updates all other visuals and it would be great to have the line chart update as well.

Kind regards

Michael

[v-junyant-msft · Accepted solution]

Hi @mike_newbs ,

Please try this way:
You can use this DAX to create a new measure:

Accepted = 
DIVIDE(
    CALCULATE(
        COUNTROWS('Table'),
        'Table'[Acceptance status] = "Accepted"
    ),
    CALCULATE(
        COUNTROWS('Table'),
        REMOVEFILTERS('Table'[Acceptance status])
    ),
    BLANK()
)

Sorry, the graphs don't look great created because the data was randomly created by me, but you should be able to use this DAX to achieve what you need. For Waiting to be accepted and Not accepted you just need to fine tune them in the DAX.

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

[mike_newbs]

Hello @v-junyant-msft 

Thank you very much for your help, thats perfect.

Kind regards

Michael