15th August 2020 Power BI – Q&A Synonyms Update Q&A allows report readers to ask questions regarding the report data. Natural language interpretation can be improved by using Q&A synonyms. Categories Power BI/Updates
1st August 2020 Power BI – Endorse a Dataset as Promoted or Certified Connecting to an existing dataset is highly recommended if possible. To encourage report builders to select the right datasets you can endorse a dataset. Categories How to/Power BI/YouTube
25th July 2020 Power BI – Gradient Legends The July 2020 update to Power BI introduced a new feature of Gradient Legends to help annotate the colours used in a colour scale conditional formatting. Categories How to/Power BI/Updates/YouTube
15th July 2020 Power BI – Introducing Sync Slicers How many reports have duplicate slicers across the pages and the report reader has to re-apply the slicer values on each page? Sync slicers fixes the problem. Categories How to/Power BI/YouTube
10th July 2020 Power BI – Personalize Visuals The May 2020 update for Power BI includes the option for a report reader to personalize visuals and save the changes as a bookmark. Categories Power BI/Updates/YouTube
22nd June 2020 Power BI Introduction Resources This post is to support my virtual session at London Reactor on 22nd June. It will include the recording and links to the data source and the final Power BI Report. Link to Reactor Recording will go here…. Data Used and Final File Data in a single Excel File Final PBIX File Links to great Resources Guy in a Cube... Categories Power BI
31st May 2020 Power Apps – Embed a Power BI Chart This post covers how to embed a Power BI chart from a published report into a Power App, handling a tile that doesn’t appear and then filtering the embedded chart. Categories How to/Power BI/PowerApps/YouTube
15th April 2020 Power Query – Replace values for whole table Today’s challenge was to replace the values on all the columns in the query when I know the columns will change so I don’t want to name them. Categories M/Power BI/Power Query
3rd April 2020 Power BI – COALESCE Function to Remove Blanks This post walks through a simple use of the coalesce function to prevent a measure returning Blank. This function was introduced to Power BI in March 2020. Categories Power BI
25th March 2020 Power BI – Introducing the Hierarchy Slicer The new hierarchy slicer allows for data to be sliced based on different levels. This will reduce the number of slicers required on a report page. Categories How to/Power BI