Forum

You need to make sure the date field comes from your Date table, not the fact tables 1 and 2.

Hi Andrew, Welcome to our forum! In the attached file I've added a conditional column for the name that appears above each section. It's not cle...

Hi Annalisa, Thanks for sharing your file. I cover this technique in my Excel Dashboard course in detail. The way the password works is every va...

Hi Deirdre, I disagree. To me the position of the final pink square in chart 2 represents 88.9% i.e. there are 88 fully shaded squares and the fina...

Hi Annalisa, No file attached. You need to click the yellow Start Upload button after selecting your file and then wait for the grey check mark bes...

Hi David, Welcome to our forum! You could use the filters on a Table to filter for employees that fall between date and time ranges. You can't do t...

Hi Deidre, These charts look correct to me. Chart 2 has 88.9% for Dose 1, which takes you to the 9th row of the chart i.e. nearly 90%. Chart 1 is 9...

Hi Stacey, Add an index column before your unpivot step. Mynda

Hi Bax, Turn off background refresh in the Power Query editor settings. Mynda

Hi Yog, Welcome to our forum! Maybe you can change it to a multi-cell array formula. That way you select the cells first, then enter the formula...

Hi Deidre, Welcome to our forum! I can't tell from the screenshot what the cell references are and then compare it to my example. I can see that...

Hi Simon, If you just have a list of the URLs then it probably should be: Source = Web.Page(Web.Contents(&"&PageStart&"&)) My...

Hi Pieter, Personally, unless it's causing performance issues, I'd use this approach. What you're wanting to do isn't an ideal tabular layout, so t...

Hi Simon, No silly questions here 🙂 If you have created a table containing all the horse names, which in my example are the page start numbers...

Hi Pieter, You don't need to split each column separately. Simply merge the columns using the same delimiter, then split them in one step. See file...