Forum

Hi Dave, If you prefer to do this in Power Query then you can split the date into month and year columns, then join them back together in a custom ...

Hi Joachim, Alan and I had the same idea. My PivotTable also has subtotals. Mynda

Hi Julie, It sounds like you're selecting multiple cells containing the dates before you right-click. You only need to select one date cell, then r...

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

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

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

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

Great to hear you figured it out, Marti!

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

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

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

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

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

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

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