Forum

Hi Luciana, When working with dates you need to create a date/calendar table. I also had to create a separate dimension table for your accounts lis...

If it didn't work maybe you need to add one row of data to the file that you later filter out. e.g. Date AA BB A B C D 1/1/299...

Hi Scotty, With line charts it's ok to start the vertical axis above zero as there are no columns to subconsciously compare the height of. The degr...

Hi Nadeem, When you get files from a folder it requires those files to have the same file structure i.e. column labels if you want to append on imp...

Hi Luciana, Thanks for the mockup. Will the AccountList only ever contain one balance for each account, or will there be more balances added as tim...

Hi Tracy, Your image is so small that I had to zoom in to see it, but then it's too pixelated to read. You could make your window size considerably...

Hi Blanka, If you want to look at claims by 'Construction' then you need to assign that field to the Policy number in the PolicyID table. Then you'...

Hi Bob, 1. I'd have thought the house price trends should show either all data or that of the LGA area chosen in the Slicer. No need for the local ...

Hi Malcolm, Welcome to our forum! You can use this formula in the first cell and then copy down: =INT((ROW(E1)-1)/3)+DATE(2019,10,19) M...

Nothing attached, Nadeem. Also, please state your question in the forum as opposed to only in the file. This helps others search for help on the same ...

Let's say you want a list of 12 months worth of the first Monday of each month starting with January 2019. First select 12 cells in a column, then ent...

Hi Punyata, Colour changes to chart series usually occur when colours are applied while the chart is in a filtered state, i.e. not all series are v...

The labels will only display horizontally if you make the chart wide enough for them to fit. You can't force them any other way.

Hi and welcome to our forum! Please see this tutorial on Conditional Formatting using Formulas to understand what you put in your question mark pla...

Hi Alison, There is no picture attached. Also, I'm not sure what you mean by "is it possible to next the axis". That said, you probably need to ...