Join us live as we answer your questions about Power BI!

πŸ’₯ 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 NOT re-post your questions! We’ll get to as many questions as we can.
πŸ‘‰ If you SPAM your question, you will be put in timeout

Q: How can I put percentile lines on a chart when the option isn’t available in the analytics section? Is there another measure I can add?

Q: Anything about new Calculation Groups in today’s session?

Q: Alongside the addition of calculation groups, is there anything else that is now enabled by using external tools that excites either of you?

Q: How to show YouTube channel subscriber count by country using Power BI.

Q: Is there a way to make a date slicer dynamic? for example Last 5 months is dynamic but I have data that comes with future days. my max date is greater than TODAY’S date.

Q: Is there any way to freeze first two columns in a table visual?

Q: Greetings from Australia !! If I updated the visuals in a Report in web app. How do I push those changes back to desktop version of same report? Thanks guys.

Q: How can we implement conditional formatting on row headers of a matrix visual?

Q: In conditional formatting, is there any way to make font bold?

Q: Greetings from South Africa having issues with dynamic axis and 445 calendar doesn’t allow me to activate both relationships

Q: how do you get around the issue where you can’t refresh a report that access sources by both gateway and web? like an om-premise NAV and SharePoint?

Q: May 2020 report server does not work with September 2019, do you know if their is a work around?

Q: Why do some people ignore the repeated instructions and instead keep posting the same question over and over without a “Q: ” prefix?

Q: what’s the song playing now for intro?

Q: Is there a way to use a disconnected table in a table visual, but if the measure returns zero to hide the item in the visual?

Q: Month slicer breaks down when switching between bookmarks, turns into a frozen field with a funnel icon. What can be the reason for that? All fields are set correctly and the bookmark works fine

Q: How do you make a % diff measure based on 1 date column and a value. The dates are not monthly or daily. Previous date measure VAR would help.

Q: @Patrick, How can we implement the incremental refresh with integers in dataflows. To enable incremental refresh in dataflows you need to have datetime i think, but my datasource is SAP BW

Q: you are on the inspire?

Q: I need to show overall averages but with RLS it’s only showing average for that level of security. I have multiple tables each setup as user table” > β€œinvoice#+user” > and β€œinvoice table

Q: Can you show how to calculate a client churn?

Q: Is there any limit on number of columns for a table and matrix visual?

Q: Video on not needing a date table! you cause me problems Patrick

Q: Who is responsible for the arm tat Patrick?

Q: Am I correct in thinking I can’t sort by rows in a matrix other than the first row? for example I have NHS numbers then DATE in that order in rows but it will default to sorting by nhs no. ?

Q: Would you recommend Power BI or SSAS for building enterprise scale models?

Q: Patrick will like this one, I’m using one model to rule them all, but now I added RLS. the problem is that I cannot test the roles with the reports that use the live connection. Gracias

Q: how can we change the data source from odbc to Azure SQL server database in the report already published ?

Q: Best place to create the datetable -> database – Power Query – DAX or auto ? I think there is a lot of confusion…

Q: How do I embed the dashboard in my c# application, I have web browser widget coded.

Q: How to get a % variance of value from previous date when the dates are sparse?

Q: Hey Guys! I have a really big dataset model with around 25ish tables at 2GB size. My IT department is pushing me to separate it into multiple tiny datasets and wait for Comp models. What to do?

Q: hey guys , am I correct in thinking I can’t sort by rows in a matrix other than the first row? eg: I have NHS numbers then DATE in that order in rows but it will default to sorting by nhs no.

Q: TRANSLATIONS : I have a on-prem SSAS model with translations, however those are NOT managed by the gateway. When I connect to on-prem SSAS, translation are not managed

Q: What would be the best chart to use in displaying 40 plus test stations in Manufacturing? currently I use charts and it’s slow in refreshing.. thanks

Q: I have the same report published to multiple workspaces and all point to the same dataset. Is there a way to apply a visual update to all workspaces at once? (ex. adding same text box to all) Thx!

Q: There are lots of little bugs like the formula bar expanding out to fill (block) entire screen. Any reason why this hasn’t been fixed yet?

Q: Last Data Refresh is not showing in Microsoft Team if I share with team but in POWERBI service it shows..any solution to it?

Q: Can Power BI show events labels as annotations on a line chart of a time series dataset? Some AppSource apps almost do this but they don’t also accommodate drilling up and down to the minute level.

Q: what is the best way to share data among the business using office365 but all users might not be pro?

Q: Is there a way to use a disconnected table in a table visual, but if the measure returns zero to hide the item in the visual?

Q: Is there a way to use a disconnected table in a table visual, but if the measure returns zero to hide the item in the visual?

Q: How do you create a hierarchical list by Manager or 1up? I’d like to select a Manager a see list of every direct reports and their direct reports. also how many columns would be involved?

Q: Hi Guys, I have 2 tables with different data. i need to create a new table which the value is from both of those table (no calculation though). can you please do a quick demo for this? thanks!

Q: Is there any way we can integrate the power BI Dashboard Q&A section with Alexa or Ok Google? Instead of typing Question, we can ask voice question.

Q: Where do I get your dope Power BI shirts, I want merch to rock power. BTW I passed the DA-100 exam so I’m a Data analyst

Q: what is the hype about disconnected tables? I am hearing lots of buzz on those right now

Q: how to keep default selection today’s date always in a slicer?

Q: How can I dynamically select columns in the table visual? (remove / Add cols) , like giving user a set of cols so they can choose the columns based on preference.

Q: Hey guys. I’m having trouble using ALM toolkit to push changes from on PBIX to another PBIX. Do you know if this is possible?

Q: How to build a narrative based on sales by salesperson. I’ve seen something using variables. Natural language for the interpretation of measures

Q: Hey guys. How would you setup your gateway settings to avoid downloading Azure Postgresql DB data to premises when refreshing it as a data source?

Q: will we get an update to use “or” clause with relative date filter?

Q: when exporting a visual to Excel, need a way to copy/paste the context, i.e.all the filters that are active (sorry repeat, I did not add ‘Q’ last time)

Q: can u please tell me about vscode

Q: Isn’t your wife managing the chat?

Q: how can we give the width size for all the columns at once?

Q: Yoo from London. what are the commonalities among Power Automate , App and BI from enterprise gateway point of view ?

Q: I have a data model with 20 tables with a lot of DAX. I have a total of 30 pages and whenever I open pbix and when I try to create a new measure it takes a lot of time to load. How do I fix this?

Q: im sorry i dont know if you answered my question , can i do print PDF ?

Q: Greetings from Lagos, Nigeria! How do I connect to Dynamics 365 Finance & Operations from PBI Desktop? Can’t find any helpful documentation online

Q: Patrick, How we can achieve incremental refresh with Integers in DATAFLOWS, as DATAFLOWS needs to have DATETIME field in the entity ?

Q: how can we use “Userrelationship” DAX function while RLS in place ?

Q: I set up Conditional Formatting for Visual Titles using a list of values. How do you change the visual title to a standard title name when nothing has been selected?

Q: For refreshing the data using the gateway is it limited to 48 times a day in PBI Premium. Is there a way to do more frequently using incremental refresh?

Q: in my data, i have 1 Project Name Column have multiple task name. each task name have different task index. how do i visualize that project status by only the highest task index?

Q: can we implement conditional formatting on row headers of matrix

Q: Is there a way to show data labels already in the data on a shape map?

Q: Can you download all External Tools together all at once?

Q: Is it possible to pull Dataflow refresh status using REST API or any other way?

Q: Which & why? Power BI w XMLA endpoint, SSAS LiveQ

Q: how to pass rest of the slicer value except selected one in stacked chart x axis

Q: Calc group integrated via backdoor-tabular editor, next mission : dark theme πŸ˜‰

Q: For refreshing the data using the gateway is it limited to 48 times a day in PBI Premium. Is there a way to do more frequently using incremental refresh?

Q: Best place to create the datetable -> database – Power Query – DAX or auto ? I think there is a lot of confusion…

Q: Would you recommend Power BI or SSAS for enterprise models?

Q: dataimage by cloudscope no longer works, what is the alternative?

Q: Azure Maps in Power BI, is it supported in Report Server?

Q: I teach Power BI intro lots, what 3 things do people not get taught that they should be taught

Q: Why do I hear a music bed on this presentation? A bit distracting.

Q: Hi guys..Which is better from performance point of view?- Creating calculated columns in the query editor or outside where we write dax queries?

Q: Did you guys ever run into why Consumer and Gov PowerBi users can’t share reports? I had to “give” one or our consumer licenses to of GOV cust.

Q: What is the best method to share reports/data to the business (office365) but not all will have pro license? purely for viewing.

Q: Knowing that External Tools is a love letter to the developers who have been on the journey for a while, how do we make sure our new post-DIAD friends don’t feel overwhelmed with all these things?

Q: When you define a table using a Dax expression, is it calculated and caches at model refreshed, or recalculated on the fly every time it is used in a visual?

Q: I have one table that has cost by function by region and one table with cost by cost types by region how can I marry both tables?

Q: Patrick, a couple years ago you made a video about hiding blank hierarchy members in AS. Have you tried it with external tools and .pbix with any success?

Q: What Marvel Phase 1 movie is your favorite and why is it Iron Man.

Q: Ever thought about making some of these live sessions a happy hour session (say on a Friday afternoon?). I can’t think of a better way to talk tech than to do it over good beer.

Q: I have a lot of user created PBIX files that have no documentation behind them. I am exploring how best to guide them add notation intra-PBIX file and use DAX studio to extract. How would you do it?

Q: yooo from London.. Enterprise Data Gateway what features are common among Power BI , Power Automate and Power Apps?

Q: In line chart I want to show actual + forecasted data, however, the forecasted line needs to diff. color?

Q: Am I correct in thinking a Matrix will sort by first “row” (column) by default? for example I have nhs no. in first column and date in second if i sort by the date it won’t go in order.

Q: What would you say to users who insert an image on a PBI report, and that image has a “photo” of visuals with data? (end user says they use the image to improve report performance 😟)

Q: Hey, big fan! Is there a power shell script I can run or backend way for me to allow end users to export more than the limited rows to excel? I don’t want them using analyze in excel.

Q: are there any options for inputting end user narrative alongside BI visuals? with on prem and without MS teams (we are on Atlassian confluence closest I got was embedding the dashboard as iframe)

Q: I have a column that has tags concatenated with a semicolon. If I need to get the number of rows that contain each tag, do I need to use a disconnected table that has a list of each individual tag?

Q: Do you think they’ll ever adjust the licensing for employees that just need to consume reports? We’re too small for prem, but pro enables too many options for emp that just need to consume.

Q: When will get get query scale out in PBI Premium????????? PLEEEEEEEASSSSSEEEEE

Q: What can a calculated column do that a measure can’t?

Q: Do you have any tutorial on On-prem Power BI report Server Installations and Configuration ?