Forum

Hi Deidra, Thanks for clarifying. It sounds like you are using the Power BI service to get data from a Workspace that your IT people have published...

Hi Amit, If you have multiple countries in your dataset, then you should have a country column. In which case you can merge the city or state and c...

Hi Deidra, Its' great to hear you're implementing Power BI. I'm a bit confused as to whether you're wanting to use the Power BI data in Excel o...

No, I mean the empty cells have non-printing characters. The numbers look ok. Load the table to Power Query, make sure all empty cells display as '...

Hi Vijay, Looks like there are some non-printing characters in the cells of the FX table that appear blank. If you select a bunch of empty cells, y...

Hi Kasey, Your spreadsheet should have 3 columns: Plant Type (tomato, beans, corn etc.) Task (sow, plant, harvest) Month (enter proper dates...

Great idea! Thanks for sharing.

Hi David, If I understand correctly, you want a running total. See this tutorial on running totals in Power Pivot. You could also try using the...

Hi Sue, Unfortunately, there's no way to copy the formatting when you use 'show report filter pages'. The macro will be the way to go. I would ...

Hi Brian, Welcome to our forum! You can use the INDEX function to return an array. In your formula it would look like this: =FILTER(FILTER(tb...

Hi James, You can use this formula to put the resource value in the Gantt cells: =IF(MEDIAN(K$17,$C18,$D18)=K$17,$J18,"") You'll need t...

Hi James, I'm not sure what you mean by 'the Gantt chart area to the right' as there was no placeholder column in your file to indicate where exact...

Hi John, A couple of options: 1. use Excel forms to capture the information from the various users. 2. Try Office Scripts instead of VBA. Off...

Hi Kenneth, You need to create a custom PivotTable style for the header rows. Choose a style that's close to what you want, then right-click > d...

Hi Christine, Yes, Power Query can fix these dates. It looks like this might have been a text or CSV file that you've opened in Excel? I say this b...