cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
einarrattgard
Helper III
Helper III

Filtering Measures

Hello!

I have created lots of measures and I want to make an "Executive Summary"-Page where you can pick one of the measures and see in all graphs. For this, my plan was to make a table like this:

 

Table of Measures = 
{
    ("Inventories", [Days Inventory Outstanding Deliveries]),
    ("Availability", [Availability %]),
    ("Broken Promises", [Broken Promises %]),
    ("Accidents", [Accidents per 100 Employees]),
    ("Capacity Utilization", [Capacity Utilization %]),
    ("MCLI",[MCLI]),
    ("Productivity",[Productivity]),
    ("Flexibility",[Flexibility Index])
}

 

But all of the measures are dependant on that you pick a certain time period. Is there a way for me to copy a column from a table and then add this code to each row in that column?
Like this:

einarrattgard_0-1626079214506.png

 

1 ACCEPTED SOLUTION
amitchandak
Super User
Super User

@einarrattgard , do you need a measure slicer? This means if select measure A from slicer visual/s will display Measure A, if select Measure B that will be displayed

 

if yes refer

measure slicer
https://www.youtube.com/watch?v=b9352Vxuj-M
https://community.powerbi.com/t5/Desktop/Slicer-MTD-QTD-YTD-to-filter-dates-using-the-slicer/td-p/50...

 

calculation groups
https://www.sqlbi.com/blog/marco/2020/07/15/creating-calculation-groups-in-power-bi-desktop/

 



Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Dashboard of My Blogs !! YouTube Channel !! Connect on Linkedin

Proud to be a Super User!

View solution in original post

1 REPLY 1
amitchandak
Super User
Super User

@einarrattgard , do you need a measure slicer? This means if select measure A from slicer visual/s will display Measure A, if select Measure B that will be displayed

 

if yes refer

measure slicer
https://www.youtube.com/watch?v=b9352Vxuj-M
https://community.powerbi.com/t5/Desktop/Slicer-MTD-QTD-YTD-to-filter-dates-using-the-slicer/td-p/50...

 

calculation groups
https://www.sqlbi.com/blog/marco/2020/07/15/creating-calculation-groups-in-power-bi-desktop/

 



Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Dashboard of My Blogs !! YouTube Channel !! Connect on Linkedin

Proud to be a Super User!

View solution in original post

Helpful resources

Announcements
PBI_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

Welcome Super Users.jpg

Super User Season 2

Congratulations, the new Super User Season 2 for 2021 has started!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!