Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now

Reply
mike_newbs
Frequent Visitor

Create a line chart visuals that track %

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.

 

mike_newbs_0-1703087678929.png

 

The data I use is basically:

 

Lead createdProductAcceptance status
AprProduct 1Accepted
AprProduct 1Accepted
MayProduct 1Waiting to be accepted
MayProduct 2Not accepted
JunProduct 3Not 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

 

1 ACCEPTED SOLUTION
v-junyant-msft
Community Support
Community Support

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()
)

vjunyantmsft_0-1703127370377.png

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.

View solution in original post

2 REPLIES 2
v-junyant-msft
Community Support
Community Support

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()
)

vjunyantmsft_0-1703127370377.png

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.

Hello @v-junyant-msft 

 

Thank you very much for your help, thats perfect.

 

Kind regards

 

Michael

Helpful resources

Announcements
OCT PBI Update Carousel

Power BI Monthly Update - October 2024

Check out the October 2024 Power BI update to learn about new features.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

October NL Carousel

Fabric Community Update - October 2024

Find out what's new and trending in the Fabric Community.