Simulation of the results depending on a parameters

[Anonymous]

Hi everyone,

I would like to create a flop of relay where it shows me the worst relay regarding the number of KO delivery. I want to adjust with a parameter the number of relay that is shown. then I want to visualise a simulate level service where all the relay that are shown have 0 KO delivery.

For the Flop visual it's ok already

For the rest I am totally lost ...

I know how to do it with Tableau but didn't find it yet on PowerBi.

[Anonymous]

Hi @Anonymous ,

You may try Stacked Bar Chart or Clustered Bar Chart to get such output.

But sorry for that the information you have provided is not making the problem clear to me. Can you please share more details about your tables and your expected output to help us clarify your scenario?  Or share me with your pbix file after removing sensitive data.

Refer to:

How to Get Your Question Answered Quickly - Microsoft Power BI Community

How to provide sample data in the Power BI Forum - Microsoft Power BI Community

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

[Anonymous]

Hi @Anonymous,

I have some problems with my computers currently and I cannot acces to my Bi file anymore. I'll get back to you as soon as I can.

If I try to explain without more pictures is that I have an Excel file with all the deliveries YTD. Each delivery is associated to one and only one relay. On each delivery I know the exact hour of arriving and the minimum and maximum hour in wich it should arrive. Thus I can determinate if the delivery is on time or KO. 

In my Bi I created a bar chart with a TOP N filter on the number of delivery KO YTD. 

What I want is to simulate a new weekly level of service (number of delivery on time/total number of delivery) by switching all the delivery of the relay that belongs to the TOP N from KO to on time.

The aim is to show a simulate level of service if all the relay belonging to the TOP N is 100% effective.

I don't know if its clear for you or not. Please let me know.

Best Regards

Charly SUAIRE