Forum

Mynda Treacy
@mynda
Admin
Member
Joined: Jul 16, 2010
Last seen: Jun 8, 2026
Topics: 0 / Replies: 4783
Reply
RE: Extract Profit or Loss amounts from Stock Trades

Hi Joachim, If your data is in a tabular layout then you can use a PivotTable to easily summarise the data, but based on the layout above, I suspec...

4 years ago
Reply
RE: shrink to fit text

Hi Lynnette, You'd have to write some VBA to do this, although I'm not even sure VBA could detect if the text is not fitting in a cell in order to ...

4 years ago
Reply
RE: Can you make value filters dynamic, based on slicer choice?

Hi Belinda, Please see this tutorial on switching measures based on slicer selection. Mynda

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

Hi Jim, You need to use Power Query to get the data from Excel and bring it into Power BI. You also need to learn Row Level Security and publishing...

4 years ago
Forum
Reply
RE: Blank Rows in the Middle of my Table

Great to hear you figured it out, Marti!

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

Fair enough, Erwin. You know your data better than me. I honestly don't understand what the data represents!

4 years ago
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...

4 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...

4 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...

4 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...

4 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...

4 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 ...

4 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...

4 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...

4 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

4 years ago
Page 43 / 319
0