Forum

Hi Jessica, The User Report does not have a relationship with the Absolute Values table. If you delete the relationship between the GL by User Repo...

I don't think you're going to get an answer for this, John. It's the switching of the values from 73 to 37 that is not something Excel is designed to ...

Hi Shannon, Welcome to our forum! You can use VLOOKUP with an approximate match for this. Or use Power Query to do the equivalent of a VLOOKUP appr...

I've not seen this before, Bax. Maybe the measure related to the Slicer is not calculating. Have you tried filtering using the Filter buttons instead ...

Hi Paul, The overall size of the chart will not adjust so that the bars/column remain the same width. This is by design because often a chart will ...

Hi Jorge, Please see the file attached. I used the techniques described in this Power Query Unpivot tutorial for repeating rows. Note: your 'end...

Hi Jorge, Please create a mock up of your desired result based on the data in Sheet1. There is a lot of information in this sheet, however from you...

Hi Steve, You shouldn't need to translate your file as Excel will automatically convert formulas to whatever language settings we have. It might be...

Hi Steve, It's a bit tricky to fully comprehend the issue without a file, however I wonder if you can use this technique to get multiple sheets fro...

This happens with bar charts. You can either sort the PivotTable in ascending order or format the chart axis and under Axis Options, check the box 'ca...

To add a slicer to an existing PivotTable, select a cell in the PivotTable and then go to the Insert tab or PivotTable tab > insert slicer. That wa...

Hi Sherry, Try this in cell C2, then copy down: =INDEX(Sections!$C$2:$C$8,MATCH('Section List'!A2&'Section List'!B2,Sections!$A$2:$A$8&S...

Hi Jessica, I'm not sure what you mean by 'how the tables use the query'. What tables? In the first example I'm not creating a dynamic variable....

Hi Richard, You can use the number grouped data in Power Query technique. Mynda

Hi Ryan, Welcome to our forum! Your conditional formatting appears to be working correctly to me. Your dates span 2020 through to 2022, so you'l...