Visual Calculations in Power BI

Visual Calculations in Power BI

46.702 Lượt nghe
Visual Calculations in Power BI
⚡⚡⚡More information in the description below⚡⚡⚡ A first look at Visual Level Calculations in the February 2024 release of Power BI Desktop. Looks very promising, should simplify a lot of common DAX requirements. ⚠️ Formatting Update: There's new formatting options as of August 2024 https://youtu.be/a6lI_B58wqQ?si=t0ldp_zZUb5B06Oy For more format options see https://learn.microsoft.com/en-au/power-bi/create-reports/desktop-custom-format-strings?WT.mc_id=M365-MVP-5002589 If you need to do further calculations on a field AND you want to display it formatted then you will need to create a duplicate unformatted column and hide the original non formatted column that is used in further calculations. At this stage you also cannot sort by a measure value (the RUNNINGSUM doesn't respect the sort order of a visual if it's sorted by a measure) Instead you'd need to do something like this RUNNING TOTAL by Units= SUMX(WINDOW(1, ABS, 0, REL, ROWS, ORDERBY([Units], ASC)), [Units]) The team and I at Access Analytic develop Power BI and Excel solutions for clients in Australia and deliver training around the World. https://accessanalytic.com.au/ Did you know I've written a book "Power BI for the Excel Analyst"? https://pbi.guide/book/ Connect with me https://wyn.bio.link/