Charts can be hard to understand sometimes. Ambiguity is never a good thing. Here are some tips for using data labels in Power BI to help your consumers better understand the meaning of the values.
📢 Become a member: <a href="https://guyinacu.be/membership" Continue reading “Some tips for your data labels in Power BI”
Today, a deeper dive into the new Excel functions TOCOL and TOROW.
Table of Contents
(0:00) Ignore errors with TOCOL
(0:46) Non-contiguous ranges with TOCOL
(0:56) 3-D Ranges with TOCOL
(1:26) Using TAKE and HSTACK
(2:01) VSTACK for Headings
Fourteen new functions in Excel: TEXTSPLIT, TEXTBEFORE, TEXTAFTER, VSTACK, HSTACK, CHOOSECOLS, CHOOSEROWS, DROP, TAKE, EXPAND, TOCOL, TOROW, WRAPCOLS, WRAPROWS.
Links to Help topic for each:
TEXTSPLIT: https://support.microsoft.com/en-us/office/textsplit-function-b1ca414e-4c21-4ca0-b1b7-bdecace8a6e7
TEXTBEFORE: https://support.microsoft.com/en-us/office/textbefore-function-d099c28a-dba8-448e-ac6c-f086d0fa1b29
TEXTAFTER: https://support.microsoft.com/en-us/office/textafter-function-c8db2546-5b51-416a-9690-c7e6722e90b4
VSTACK: https://support.microsoft.com/en-us/office/vstack-function-a4b86897-be0f-48fc-adca-fcc10d795a9c?ns=xlwaenduser&version=16&ui=en-us&rs=en-us&ad=us
HSTACK: Continue reading “Excel 14 Amazing New Functions in Excel – 2469”
What’s up with the wait time in Power BI Dataflows? Do we just live with it? What’s going on and what can we do about? Adam, has you covered!
Understanding and optimizing dataflows refresh
https://docs.microsoft.com/power-bi/transform-model/dataflows/dataflows-understand-optimize-refresh
📢 Become a member: <a Continue reading “So, we just wait???”
Dynamic M Parameters for SQL are here in Power BI! YES!!! Let’s revisit a Power BI solution and how we can take it to the next LEVEL using these!
LEVEL UP Power BI Conditional Drill with Paginated reports!
rel=”nofollow”>https://youtu.be/43CwBmaym8Q
Teo Lachev’s Blog:
https://prologika.com/power-bi-dynamic-m-query-parameters-reloaded/
Chris Webb’s Blog:
https://blog.crossjoin.co.uk/2022/02/20/tsql-table-valued-functions-and-dynamic-m-parameters-in-power-bi-directquery/
Documentation:
https://docs.microsoft.com/power-bi/connect-data/desktop-dynamic-m-query-parameters
📢 Become a member: https://guyinacu.be/membership
*******************
Want to take your Power BI skills to the next level? We have training courses available to help you with your journey.
🎓 Guy in a Cube courses: https://guyinacu.be/courses
*******************
LET’S CONNECT!
*******************
— http://twitter.com/guyinacube
— http://twitter.com/awsaxton
— http://twitter.com/patrickdba
— http://www.facebook.com/guyinacube
— https://www.instagram.com/guyinacube/
— https://guyinacube.com
***Gear***
🛠 Check out my Tools page – https://guyinacube.com/tools/
#PowerBI #PowerQuery #GuyInACube
Oops! Forgot to show how we added the Power BI Report page tooltip from our sparkline video. Well, here it is!
Add a little info to your Sparkline in Power BI
https://www.youtube.com/watch?v=NkRVaRUVO7s
📢 Become a member: https://guyinacu.be/membership Continue reading “Oops! Forgot to show this…”
Antony in Toronto brings us two more Excel AutoSum Oddities.
This was part of my hour-long session on Excel Oddities, Curiousities and Mysterious Wonders for the Vancouver Modern Excel Users Group. Watch the entire hour here:
https://youtu.be/H7rSetB7IRo?t=277
💥 30 minutes: Open Q&A (Public)
💥 Then… Members Only Chat (Public can watch & Super Chat for Questions)
📢 RULES FOR Q&A: 📢
👉 Put a “Q:” in front of your comment to help us identify questions!
👉 Super chats take priority
👉 Do Continue reading “REPLAY Power BI tips from the Pros – LIVE w/ Marco Russo (Mar 5, 2022)”
Doug from Boston needs to calculate an age in Excel.
Two easy formulas today: YEARFRAC and DATEDIF.
Today’s question from Ken: I’ve lost a slicer. I know it is somewhere on the worksheet, but how can I find it?
Thanks to Lou Pham, we have an answer. Use Home, Find & Select, Selection Pane. Select the object. Press Continue reading “F2 To Bring Selected Object Back Into View in Excel – 2471”
What are orphaned Power BI Workspaces and how do you get rid of them? What if you have a lot of them? Adam walks through some options including a PowerShell script!
Delete Group/Workspace API:
https://docs.microsoft.com/rest/api/power-bi/groups/delete-group
AddUserAsAdmin API
https://docs.microsoft.com/rest/api/power-bi/admin/groups-add-user-as-admin
Power Continue reading “Dealing with orphaned Power BI workspaces”
Hybrid Tables are an incredibly powerful feature in Power BI. But what if you wanted to create them outside of Power BI Desktop? Patrick shows you how you can do just that in Tabular Editor!
–This Year
let
Source Continue reading “Create Hybrid Tables with Tabular Editor for Power BI? YES!!!”