Drill 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.mutate
Dynamic Date measure for custom tooltip when Drilling up or Expanding
I am creating a custom tooltip for a line chart. Users can Drill up or Expand to the next level in the date hierarchy (Year - Quarter - Month). In the tooltip, I'd like to write a measure to display the Year only when viewing on 'year' level, Year and Quarter only when viewing on 'quarter' level , Year and Quarter and Month name on 'month' level. Or any other alternatives. Currently I'm placing textboxes "Year","Quarter","Month" next to respective card visuals (using SELECTEDVALUE()); but a. it's difficult to align them nicely and b. when you're on the 'year' level, the quarter and month cards are blanks, while the texts "Quarter" & "Month" are still there.
Measure with multiple hierarchy levels
Hi, I have some issues on creating a DAX measure with multiple hierarchy level. I have 1 table with unique client code and 4 hierarchy level. Hierarchy 1 contains Hierarchy 2 Hierarchy 2 contains Hierarchy 3 Hierarchy 3 contains Hierarchy 4 Hierarchy 4 contains Client Code I use the relations as descripted in the screenshot. Each hierarchy level is connected to the main hierarchy table. Then each one is connecting to the table with the values. I am using this kind of relation because 'Code Hierarchy' in 'Table' can contain items from Hierarchy 1 or 2 or 3 or 4. When i use drill on a simple graph with the 4 level and a simple measure like Average(Value), i don't get all the data. (i understand why) I have tried some measures with ALL() / ALLSELECTED() / RELATED() / etc ... but it didn't work ... Measure = CALCULATE( AVERAGE(TABLE [Value]); ... ) Could you help me please ? Regards,
