Hello guys, Welcome to Africa's Largest Video Search Engine, and you are watching Visual Calculations in Power BI. and this video is uploaded by Access Analytic at 2024-02-17T05:07:49-08:00. We are just promoting this video only for entertainment and educational purpose only. I hop you like our Video Search Engine. [myfQK40yV-I]
| Name | Visual Calculations in Power BI |
| Video Uploader | Video From Access Analytic |
| Upload Date | This Video Uploaded At 17-02-2024 13:07:49 |
| Video Discription | ⚡⚡⚡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: At this stage it's necessary to wrap in FORMAT which takes this pattern Positives ; Negatives ; Zeros FORMAT( [Measure], "#,#0.0; (#,#0.0); - " ) 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/ [myfQK40yV-I] |
| Category | Howto & Style |
| Tags | Power BI | PowerBI | Visual Calculations | Visual Calcs | Visual Level Calcs | Visual DAX | DAX |
