This page has 0 threads | Add post

Exercises

Finding our exercises useful? Please consider helping us to share more!

Software ==>	Power BI (160 exercises)
Topic ==>	Quick measures (5 exercises)
Level ==>	Average difficulty
Subject ==>	Power BI training

Using a quick measure list out all the filters applied to a given page.

This exercise is provided to allow potential course delegates to choose the correct Wise Owl Microsoft training course, and may not be reproduced in whole or in part in any format without the prior written consent of Wise Owl.

Before you can do this exercise, you'll need to download and unzip this file .

Using the Excel file in the above folder create a chart, a slicer and apply a page filter. The results should look something like this:

Wouldn't it be nice to have a message box saying which filters had been applied?

From the Home tab choose Quick Measure, then from the bottom of the list choose Concatenated list of values:

All the values in the Field column will be concatenated. The Number of values before truncation box indicates how many are listed before returning etc.

Repeat this for all the columns you have used for filtering, and then insert the newly created measures into cards: