topic Re: 3 fields I need to use in Legend in DAX Commands and Tips

3 fields I need to use in Legend

gilmore_staci — Wed, 12 Nov 2025 19:04:13 GMT

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?

Re: 3 fields I need to use in Legend

MasonMA — Wed, 12 Nov 2025 20:07:22 GMT

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.

Re: 3 fields I need to use in Legend

v-karpurapud — Mon, 17 Nov 2025 05:15:01 GMT

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