Forum

Hi Michael, Even OneDrive for Business has a 10MB embed limit. If you're wanting to share reports that have a lot of data then Power BI is the idea...

Hi Lea, No, you'd have to use VBA for this. The Group Data tool might be of interest as an alternative. Mynda

Hi Ozgur, Welcome to our forum. Can you please upload your file again as it's not attached. You need to click the yellow 'Start Upload' button afte...

The time periods are different; the top ones are from 16 June to 30 June and the bottom ones are from 3 Jul to 17 Jul. If you change the dates do you ...

Hi Bob, It's not clear what you want to do or how your data is structured, but here is an example of using LASTNONBLANK with CALCULATE: Latest B...

Hi Bob, You can get files from a different OneDrive account to that of your Power BI account. You need to use the From Web connector and pass it th...

Hi Karen, Thanks for sharing your file. I would use a different chart. Please read through this tutorial on charting survey data for some ideas. ...

Hi Bob, Session 8.04 of the Power BI course covers publishing Excel files to Power BI. You need to use the 'Export' option and if your Excel file i...

Hi Lea, Use custom number format: 0.##% More on custom number formats here. Mynda

Hi Charlotte, It sounds like you didn't select the correct cell when you set up the dynamic named range. Remember, it's crucial that the cell selec...

Hi Karen, It's risky superimposing charts on top of one another because charts typically automatically scale the axes to suit the data, which could...

Hi Bob, Thanks for sharing the examples. Seeing that the Commons Library is a Power BI dashboard confirms my original idea that this is a job for P...

Hi Melanie, Thanks for clarifying. You need to set up separate rules for each Contractor that includes an AND clause in the rule formula to test fo...

Hi Bob, I'd say this is probably a job for Power Pivot, but it's difficult to say for certain without seeing your data structure and the way you wa...

Hi Alison, Your example data does not match what you're asking for. e.g. 1. In the Excel file you say "if OP_IsClosed = TRUE then send to Pow...