3 fields I need to use in Legend

[gilmore_staci]

I have 3 columns

*Response Time Met

*Restore Time Met

*Resolve Time Met

they are formulas with results of "Yes" and "No"

I need to create a column chart with these as the columns, using the "Yes", by month.  How can I get those in the legend to look like this?

[v-karpurapud]

Hi @gilmore_staci 

Thanks for reaching out to the Microsoft fabric community forum. 

I would also take a moment to thank @MasonMA  , for actively participating in the community forum and for the solutions you’ve been sharing in the community forum. Your contributions make a real difference.

I hope the provided information helps  you to fix the issue. If you still have any questions or need more help, feel free to reach out. We’re always here to support you 

Best Regards, 
Community Support Team  

[MasonMA · Accepted solution]

Hi, 

I'd suggest first unpivoting data with 'unpivot other columns' on 'Date' first in Power Query. 

In Power BI, create a simple Measure

TimeMet =

CALCULATE(

    COUNTROWS(Table1),

    Table1[Value] = "Yes")

If you are using a Date table to filter your Fact table, build a one to many relationship between these two. then plot below columns in your Clustered Column bar chart.