Creating a Dynamic Top 10 Bar Chart with Metric Value and Queue Name Fields

[manoj_0911]

Hi Power BI Community,

I'm currently working on a project where I need to create a bar chart in Power BI that dynamically changes based on user-selected metric names. In addition, the chart should display the top 10 queue names based on the selected metric value.

Here's what I'm trying to accomplish:

1. I have a table of metrics such as Offered, Answered, AHT, ASA, etc.
2. Users should be able to select a metric from a dropdown or slicer.
3. Based on their selection, the bar chart should dynamically display the top 10 queue names with the corresponding metric values.
4. Metric values can include whole numbers, durations in HH:MM:SS format, percentages, etc.
5. In Tableau, I used the Metric Value field in the columns and the Queue Name field in the rows.
---------------------------------------------------------

Tableau Screenshots

Tableau Calculation

METRIC VALUE = CASE [SELECT MEASURE]
WHEN 'OFFERED' THEN SUM([Offered])
WHEN 'ANSWERED' THEN SUM([Answered])
WHEN 'ABANDONED' THEN SUM([Abandoned])
WHEN 'MAX.DELAY' THEN [MAX.DELAY (HH:MM:SS)]
WHEN 'AHT' THEN [AHT (HH:MM:SS)]
WHEN 'ASA' THEN [ASA (HH:MM:SS)]
WHEN 'AVG QUEUE DURATION' THEN [AVG QUEUE DURATION HH:MM:SS]
WHEN 'TRANSFERRED' THEN SUM([Transfer Count])
WHEN 'SHORT ABANDONED' THEN [SHORT ABANDONED (ZN)]
WHEN 'SLA' THEN [SLA NEW (copy)]
END
------------------------------------------------------------
Could someone please provide guidance on how to set up dynamic measure names in Power BI, along with incorporating the Metric Value and Queue Name fields in the visualization, and filtering the top 10 queue names? Any help or suggestions would be greatly appreciated.

Thank you!
Manoj Prabhakar

[v-weiyan1-msft]

Hi @manoj_0911 ,

Can you share sample data and the results you are hoping for? Show it as a screenshot or excel. Or a sample pbix after removing sensitive data. We can better understand the problem and help you.

Best Regards,
Yulia Yan

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