Forum

Great to see you got it working! Thanks for sharing 🙂

Hi CY, Your series need to overlap as explained here. Mynda

Hi John You need to do this in a DAX measure so that it can recalculate at the row level context based on the filtered position of the Slicers. If ...

Hi Matthew, Thanks for sharing the file. You can use this Power Pivot technique that allows you to change aggregation methods using Slicers. It...

Hi Miguel, PivotTables don't support the MODE.SNGL function, sorry. You'd need to do this calculation either outside of the PivotTable, or using Po...

Hi John, The file you attached is the same as your original file. I've deleted it to save space on our servers. In regards to fixing your date form...

Hi Matthew, Please try uploading the file again. You need to click the yellow 'start upload' button after adding the file. Mynda

Hi Matthew, Welcome to our forum! It sounds like you need to unpivot your data so that the 'Material Properties' are in a single column and the ...

Hi Chris, I can't reproduce the problem. It doesn't wipe the total row out for me. If I filter the GrpBy_Card_Company query to exclude, say Visa, t...

Hi John, I'm assuming your financial year is July to June, in which case you can use a conditional column. See example file attached. Mynda

Brilliant, Allyn 🙂 Glad I could help.

Hi Chris, You can turn on the Total row in the Excel Table (as opposed to adding it in Power Query)? Table tab > check the box for the 'Total Ro...

Hi Bax, My guess is that this is a doughnut chart (like in your sheet2) that has manually had the fill colour removed for each blank segment, as th...

Hi Liz, You haven't said what version of Excel you have, but if you have Office 365 you may be able to use this reducing data validation list techn...

Hi Mike, I'm not sure I understand your data. I've assumed the 'Assets' column is the asset ID, as opposed to the number of assets. I understand...