Forum

Mynda Treacy
@mynda
Admin
Member
Joined: Jul 16, 2010
Last seen: May 17, 2025
Topics: 0 / Replies: 4762
Reply
RE: Chart Design - Matrix View

Hi Erwin, The trouble with stacked column/bar charts is only the first item in the stack is comparable across, in your case, the apps. Another opti...

3 years ago
Reply
RE: How can I publish daily pickup table(s) for each driver via Power BI?

Hi Jim, I suppose you could use Power BI's Row Level Security to display data specific to a driver when they open the app. You could have the repor...

3 years ago
Forum
Reply
RE: Chart Design - Matrix View

Hi Erwin, The file didn't get attached. You need to click 'start upload' after selecting your file, then wait for the grey check mark beside the fi...

3 years ago
Reply
RE: How can I format the time and keep them consistent (while refreshing) on a table or on a Power Pivot table?

Hi Jim, The file didn't get attached. You need to click 'start upload' after selecting your file, then wait for the grey check mark beside the file...

3 years ago
Forum
Reply
RE: How can I publish daily pickup table(s) for each driver via Power BI?

Hi Jim, I want to check that you're aware that each driver must have a Power BI Pro licence costing US$10/month in order to see the Power BI report...

3 years ago
Forum
Reply
RE: Power Query - Data transformation help!

Here's a tutorial on getting data from a PDF with Power Query. If you're still stuck, please upload your file again and be sure to wait for the grey ...

3 years ago
Forum
Reply
RE: COMBINING MULTIPLE EXCEL FILES USING POWER QUERY

Hi Mohamed, When you get data from a folder containing files that need cleaning before appending, you do the transformations in the 'Transform Samp...

3 years ago
Forum
Reply
RE: Bar Chart colors reset upon refresh

Hi Erwin, Welcome to our forum! Try removing all filters from the PivotTable, then apply the formatting. If that doesn't work, please share your...

3 years ago
Reply
RE: Plot rankings over time, series labels either side of chart

Hi Andrew, Yes, see this tutorial on slope charts in Excel. Warning, there's no shortcuts! Mynda

3 years ago
Reply
RE: Dynamic Drop-down List for Data From a Separate Sheet

Great to hear, Karlin! Please consider my PivotTable Quick Start course, or if you want to dive deep, our Xtreme PivotTables course. Mynda

3 years ago
Reply
RE: Calculate 1000 tasks date

No, there was no file attached. You need to click 'start upload' after selecting your file, then wait for the grey check mark beside the file size ...

3 years ago
Reply
RE: Fast last row and then create named range

Glad you like the look of Power Query, Rod. It's a game changer. If you'd like to learn more, please consider my Power Query course.

3 years ago
Reply
RE: Calculate 1000 tasks date

Hi Mohammad, Welcome to our forum. Please provide an example Excel file that illustrates your question, the data you're working with and your de...

3 years ago
Reply
RE: Fast last row and then create named range

Hi Rod, Sounds like you could be using Power Query to automate this whole process. Mynda

3 years ago
Reply
RE: Dynamic Drop-down List for Data From a Separate Sheet

Hi Karlin, Welcome to our forum! You can and should use a PivotTable for this. See the Pivot sheet of the attached file for an example. You can ...

3 years ago
Page 42 / 318