Forum

Mynda Treacy
@mynda
Admin
Member
Joined: Jul 16, 2010
Last seen: Jun 12, 2026
Topics: 0 / Replies: 4784
Reply
RE: Disable Resizing and Moving Slicer

To be fair to you, it doesn't really make sense that's it's separate from the other properties settings.

5 years ago
Reply
RE: Need to separate two names with something

Hi PB, Glad it worked now. I had to give Column by Examples 5 examples before it realised the pattern, but you can also use that technique if yo...

5 years ago
Forum
Reply
RE: Looking for ways to to add features in the Dashboard

Hi CJ, To set your sub-task start date to begin on the same date as the previous task's end date simply reference the date in a formula. e.g. given...

5 years ago
Reply
RE: Disable Resizing and Moving Slicer

Hi Helen, Welcome to our forum! The Disable resizing and moving setting is under the 'Position and Layout' settings. i.e. the first section of ...

5 years ago
Reply
RE: Need to separate two names with something

Hi PB, It would have saved us both time if your original example file illustrated the problem. You can just use a custom column to ignore blank...

5 years ago
Forum
Reply
RE: Merging Queries with Hand Entered Data

Hi Richard, If the two input files have the same structure then it's just a case of creating two queries, one for the PDF data and one for the Exce...

5 years ago
Forum
Reply
RE: 2D colour contour plot (Motor efficiency map)

Hi Salman, Welcome to our forum! That's a great question and I don't have a complete answer for you, but I'd look at the 3-D surface chart options ...

5 years ago
Reply
RE: Need to move value from row 15 to row 2 is same column.

Hi Richard, Great to hear you're making progress and enjoying the course. In answer to your second question, this part I'm not certain about ".....

5 years ago
Forum
Reply
RE: Need to separate two names with something

Hi PB, First split the column based on the last space delimiter, then merge it back together with the ampersand. See attached. Mynda

5 years ago
Forum
Reply
RE: Need only the last row for the query

Hi GK, I think what isn't clear is whether you want a separate query that isn't filtered to only include the times you originally requested i.e. 9:...

5 years ago
Forum
Reply
RE: Problem with query based on source table in Power Query

If you want the data retained from the deleted CSV file then you need to load it back into PQ based on the query output you have in the workbook. If y...

5 years ago
Forum
Reply
RE: Problem with query based on source table in Power Query

Hi Jacek, Yes, you need to create another PQ table based on the already imported source. There's no skipping this step, sorry. Mynda

5 years ago
Forum
Reply
RE: Slicer and timeline issues when having dates as column headers in table

Hi Thyra, Welcome to our forum! You're having a problem because you built your data in a matrix when it should be a tabular layout. You can use...

5 years ago
Reply
RE: Need only the last row for the query

Hi GK, I don't think you've tested my solution. If you have and it's returning something different to what you want, then please provide a file ill...

5 years ago
Forum
Reply
RE: Need to move value from row 15 to row 2 is same column.

Hi Richard, Thanks for sharing the file. In the attached you'll see the steps I took to return your desired result into a table in Rows 11 and 12. ...

5 years ago
Forum
Page 107 / 319
0