Forum

Hi Jed, Welcome to our forum! You can do this in Power BI with conditional formatting, but conditional formatting for charts isn't available in Exc...

Hi Maarten, Thanks for sharing your file. The only way to make this more responsive is to move the filtering to Power Pivot rather than the data so...

Hi Arun, Welcome and thanks for sharing your file. The purpose of the forum is to help with specific Excel questions. What you have here is a brief...

Hi Maarten, Are you able to share your file showing what you've done so far and explain in relation to the file how you'd like it to work? Mynda

Hi Steve, Welcome to our forum! There are a couple of ways you can do this but it depends on your needs. When you say 'selected clients' is this...

Hi Raj, Excel doesn't recognise dates prior to January 1, 1900, however Power Query can work with dates prior. So, while working with the dates in ...

Hi Jessica, Thanks for clarifying. You can't do this with a Pivot Chart. You need to use the Value From Cells label option, but a PivotTable will o...

Hi Scott, Welcome to our forum! Personally, I wouldn't use a doughnut chart. I think they take up way too much space and they're difficult for y...

Hi David, Please upload your file again as it didn't upload properly and I can't download it. Please be sure to wait for the green text below the '...

Hi Babsi, Welcome to our forum! You said that you want to see how the data evolves over the years, therefore you don't need to know the day or ...

I don't know. You need to tell me what the rules/logic would be. Also, the examples above don't correlate to any of the 'execution ended' times in ...

Hi Ng, Welcome to our forum. You'll notice you only have data for January in your file. In order to draw a line you need at least two months or...

Hi Jessica, It's not clear what field you want the labels to display: Sum of 2021 Budget Sum of 2021 YTD Sum of Label You mention the sub...

Hi Michael, Please see example file attached. Note: I used this technique to Number Grouped Data in Power Query. And I added Table.Buffer to the...

Hi Michael, Welcome to our forum! There are some assumptions missing from the information provided. The Job Compliance table has dates and time in ...