Power BI Intermediate Lesson 9: Drill-Through, Tooltip Pages and Bookmarks
Make reports explorable: right-click drill-through to a customer page, report-page tooltips with a mini chart, and bookmarks with buttons to switch views.
Read article →Make reports explorable: right-click drill-through to a customer page, report-page tooltips with a mini chart, and bookmarks with buttons to switch views.
Read article →Show each regional manager only their region's data: static roles, dynamic RLS with USERPRINCIPALNAME and a user table, and how to test with View as.
Read article →Titles that say what is selected with SELECTEDVALUE, and one chart that switches between Sales, Profit and Orders with a field parameter.
Read article →Report sales by order date and by ship date from one Date table with an inactive relationship and USERELATIONSHIP, plus days-to-ship and cross-year orders.
Read article →Write DAX that others can read and debug: VAR/RETURN, DIVIDE instead of /, RELATED in iterators, and a discount analysis on list vs selling price.
Read article →Row-by-row calculations with SUMX for profit, AVERAGEX for averages per customer, and RANKX for top-N rankings that respect filters.
Read article →The 25 Excel date formulas used most at work: today and month-end, adding months, age and tenure, working days with holidays, weekday names, week numbers, quarters, Indian financial year and date checks.
Read article →FYTD, last year and YoY % for an Indian April-March financial year with TOTALYTD and "3/31", SAMEPERIODLASTYEAR and a proper Date table.
Read article →Turn a general-ledger or trial-balance extract into a monthly P&L: map heads to groups, SUMIFS by month and type, gross profit, EBITDA, net profit, margins and month-on-month change.
Read article →Region share of total, product share within its category and grand-total percentages that stay correct under slicers, with REMOVEFILTERS, ALL and ALLEXCEPT.
Read article →How CALCULATE adds and replaces filters, why a measure gives different results in each cell, and when KEEPFILTERS returns blank.
Read article →GAMMALN.PRECISE is the 2010 version of GAMMALN with the same result and improved accuracy.
Read article →