Forum

I should have also mentioned that Hyperlinks are covered in lesson 5.25 of the Dashboard course.

Hi Mike, You could create two charts, one at the category level and one at the subcategory level and put a hyperlink from the category level chart ...

Hi Mike, There's no built-in/automatic way for Excel to detect the screen resolution and adjust the charts and slicers to fit. One option is to cre...

Hi Bradley, Welcome to our forum. Right-click the PivotTable > Options > Data tab. In the drop down for 'retain items deleted from the dat...

Hi Tom, See this tutorial on custom chart labels for colour coding them. Mynda

You should be able to use Power Query to restructure your data. While the PivotTables you currently have are working fine now, the multiple Mon and...

Hi David, It looks like Riny has answered your question. Please advise if not as I've lost track! Mynda

Hi Jennifer, The issue you're having is caused by the direction of the relationships in your model. If you look at the arrows on the connector line...

Hi David, It's not clear if you want a staff count by day, or whether the day data is irrelevant. If the date is irrelevant, then like Adam suggest...

Hi Matt, I would only use that approach if you wanted different chart types or different formatting for each chart. Otherwise, Slicers and Pivot Ch...

Hi David, If you read the file called 'Read me first' that was included in the Zip file you downloaded from our site, you'll find the answer to the...

Hard to tell from the screenshot as I can't even see the outer edge of the chart. At a guess I'd say the plot area is too small.

Hi Reehan, You also asked this question in our Help Desk, to which I replied. Please only ask your question in one place to save everyone time. ...

Open the query editor in Power BI (Home tab > Transform Data). Then on the Home tab > Advanced Editor.

Hi Max, I know it seems simple, but that's not how PivotTables are designed. They can't distinguish between showing the breakdown for some calculat...