Data God Guide to Power BI Metrics
Get ready to take your data analysis skills to the next level with our March 14th, 2023, user group meeting on Power BI Metrics. Join Chris Wagner, Director Data Solutions at Baker Tilly and founder of Kratos BI as he shows 3 real-world use cases for how to use Power BI Metrics like a Data God. The meeting will start at 5.30pm with refreshments. The presentation will start shortly after 6pm on Wednesday November 9th. ***LOCATION*** We'll be meeting on the ground floor of the Baker Tilly offices in Madison: 4807 Innovate Ln, Madison, WI 53707. It's on the far east side - exit the interstate on US-151 towards Sun Prairie, then exit on American Parkway. Take the first left onto Eastpark Blvd. The Baker Tilly building is 2 buildings after Cambria Suites on Eastpark Blvd. Enter through the main entrance at the front of the building - doors are locked but we'll have someone to let you in and they'll be a phone number to call if you arrive later. What3Words: ///handyman.navigating.mutateDrill Through Like a Boss: Advanced Techniques to Elevate Your Reports
Drillthrough is a great way to provide autonomy to the viewer - allowing them to choose the level of detail they want to see, while keeping your main report clean and uncluttered. This presentation will demonstrate some of my favorite techniques for expanding the typical uses of drillthrough, and making the technique more intuitive to the viewer, including: -Improved drillthrough via tooltips -Drillthrough on images -Creation of dedicated multi-state drillthrough buttons -Creation of dynamic drillthrough button text -DAX-controlled conditional drillthrough -Conditional formatting driven by drillthrough selection -Advanced drillthrough on spatial data The meeting will start at 5.30pm with refreshments. The presentation will start shortly after 6pm. ***LOCATION*** We'll be meeting on the ground floor of the Baker Tilly offices in Madison: 4807 Innovate Ln, Madison, WI 53707. This is where we met in June. It's on the far east side - exit the interstate on US-151 towards Sun Prairie, then exit on American Parkway. Take the first left onto Eastpark Blvd. The Baker Tilly building is 2 buildings after Cambria Suites on Eastpark Blvd. Enter through the main entrance at the front of the building - doors are locked but we'll have someone to let you in and they'll be a phone number to call if you arrive later. What3Words: ///handyman.navigating.mutateMastering Fabric's Metrics Layer
Carly Newsome and V Maharajh, from the Microsoft Fabric product team, will be presenting the transformative new feature designed to redefine how organizations manage and consume metrics. Metrics Hub is an innovative metric layer within Fabric, aimed at helping organizations define, discover, and reuse trusted metrics with ease. This feature allows creators within an organization to develop standardized metrics that incorporate essential business logic, ensuring consistency across the organization. Introducing Fabric Metrics Layer: A New Era of Metric Management in Fabric (preview)
Goals Reporting - Linking a Goal to a Subgoal (or a Sub-Sub-Goal...)
I've just started working with Goals and have a requirement to summarise some of the goal progress in a report for ease of use. Within the goals framework I have two overarching goals. One of them has six sub-sections (subgoals) and within those there are a number of subsequent subgoals (and sometimes a further subgoal under that). So typically it looks like this: Main Goal (Effectively a "master heading" goal). E.g. Implement BI Goals by 2023 (ID 1, for example) Subgoal under this. E.g. Prepare key objectives (ID 1-1, Parent ID 1) Subgoal under this. E.g. Identify 2022 milestones (ID 1-1-1, Parent ID 1-1) (Possibly) subgoal under this. E.g. Send user requirements by end of Q2 (ID1-1-1-1, Parent ID 1-1-1 etc) My end user is looking to see at a glance which "major" goals aren't yet completed (example in red), and their associated notes. So this means using a filter - probably a slicer - to identify the main goal, I've done that and it looks fine. What I need to do next though is create an associated matrix of subgoals under that parent ID with their status/notes etc. This is where I'm stuck - I'm unsure how to tell the matrix to reference the parent ID of the item selected in the slicer, and thus return the associated entries. Since Goals is quite tightly locked down I can access the PBIX file but I can't edit relationships or see the data tables (everything is connected to the dataset, but nothing is held locally), which leaves me largely relying on DAX. Has anyone managed to do anything similar with it yet? (Largely useless) example file: https://www.dropbox.com/s/2remz46phv6d0c6/Example%20Scorecard.pbix?dl=0PowerBI Goals (Scorecard)
Hello Team, I used the new feature of Powerbi i.e. PowerBI Goals. It is one of the very helpfull feature to showcase high level information. However, I can see the scope of opportunity to upgrade it further. Currently when we share scorecards, the reciepient can see the same in expanded version. That means all the Sub Goals listed below the main goal. Can you please add an option so that recipient can see only main goals and if someone is interested then can clisk on arrow to view the list of respective sub goals Please consider this as an idea for December updates Thanks, Mangesh
