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

Questions

Q: How to prevent object overlap on visuals?

Q: I have multiple date tables, and the data table with orders includes many date keys. How can you calculate lead time with multiple date tables?

Q: Is their a way you can do a video about the Contain function in Dax, please?

Q: Can I have a line graph with marker which can increase size depending upon the other column.

Q: Is there a way to apply conditional formatting on row headers in matrix?

Q: What’s the best source of training/book for data modeling in Power BI and * schema?

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

Q: Please can we have a calculation group example that is not YTD

Q: is there any way to access/edit report level measures from an external tool?

Q: What is the coolest thing you have done with the external tools in the last week?

Q: Does Patrick believe that this hand gesture looks like a Q?

Q: How do I create a clickable card where it filters the table on the same page. I have hundreds of records on the table with 10+ columns?

Q: Any resources you can recommend on managing multiple fact tables in your model?

Q: Is there any way to deploy just a dataset to the PBI service without publishing an actual dashboard?

Q: when does the query run for paginated reports connected to a Power BI dataset? I have a dax measure using DATESMTD that only works for the current month when run in PBI Report Builder

Q: I have a very limited set of users for which I want to implement power bi embedded..Can I deploy to production without dedicated capacity?

Q: best visuals like matrix table printing scenarios?

Q: Is it possible to integrate Power BI Report Builder as an External Tool in Power BI Desktop ?

Q: How to add vector images file in Power BI report, if yes can you suggest how?

Q: Built a matrix for c19 tracking in our hospital – uses tooltip with 1:Many relations that on hover you see patients who shared that space on that date – can i bold the main record ive hovered over?

Q: Are there more features of RLS coming soon in the Power BI development roadmap? Any improvments such as CLS (column level security) ? Thank you

Q: What’s the best way to visualize rank (league position) year on year? lack of invert axis makes it hard. multiply by -1 works but tooltip looks strange to users.

Q: How can you configure the horizontal alignment for the entire page?

Q: If I have 3 fact tables with different dates should I use seperate date tables? And If not to which date I refere in my date table? πŸ™‚

Q: What’s the first 3 DAX functions someone new to PowerBI should learn?

Q: I have a requirement to show currency and percentage value in the same column in matrix visual..How can I show different formatted values in the same column.

Q: Which connector would be the best to you use for Dynamics 365 Customer Engagement ? Direct connection to D365, CDS or TDS?

Q: ideas how to hide measures from some users but not others? like a perspective but secure.

Q: Student start date and leaving date are on a dimension table. How do I calculate the number of students on a given day? Currently expand those dates in powerquery as a new fact table but its BIG.

Q: Date filter removes the query folding but filter on string keeps it. Both return same result sets. Is that normal? didn’t try much to find answers, just thought I will ask here πŸ˜€

Q: Could you do a small DAX with the previous value on a list with sparse dates?

Q: Can we export PDF of each bookmark separately ?

Q: I’ve never really thought about perspectives before but now that external tools make them possible…what are your thoughts when they are useful in a shared model?

Q: If all dates come in as keys in one table, how do you best work with one date table in the model?

Q: I need to calculate last 15 days totals on a live data and make it dynamic such that if I click on any date from a slicer, it will return/show the totals for the last 15 days.

Q: Can you put dates on the y-axis in a line graph

Q: can power BI do pricing simulation and forecasting the simulation? examples: user wanna do cars selling simulation and wanna know it forecast when the price is up x%

Q: Is there any way I can pass parameters to Power BI Report server dynamically? I will not be using any power bi service.

Q: is there a way to dynamicaly name visuals like table or matrix column names?

Q: if i have a report (excel format) that runs every day and gets send to a sharepoint list (no overwrite) and i use that to be my source to create incremental refresh, is that feasible?

Q: Can we export PDF of each bookmark separately ?

Q: Resources for M language to learning

Q: is that possible to create multi axis chart in Power BI like tableau.

Q: Can we export PDF of each bookmark separately ?

Q: Is there a way to connect Power BI report to excel without exporting as CSV format?

Q: For high cardinality dimensions (1-5m+) how do you recommend adding in type 2 fields? Separate Dim?

Q: How to show different color line chart for a continuous time period- Apr to July- For ex: Apr to June -Actual some color and July – Forecast – other color-

Q: Why is the default setting of the page background in Power BI on 100% transparency? That is really annoying in every DIAD πŸ˜€

Q: Sql db dataset refresh fails in a secon and next secon it runs success. pre-hand shake error solution please?

Q: how to plot dates on the Y axis?

Q: are we expecting some improvement in the APPLY button coming for Slicer in the powerbi .?

Q: A YoY analysis for current month by product

Q: Can we export PDF from PBI desktop of each bookmark separately ?

Q: dataimage by cloudscope visualization isnt working, any alternative

Q: Are there any plans to allow multiple Apps baes on a single workspace, or allowing an App to display reports/datasets based on permissions given directly to the objects?

Q: what is the best way for a non developer to get started with power bi embedded?

Q: data modeling technique for multiple datetime fields in a factless fact? example start and end datetime like a delivery window.

Q: Are there any options for end user comments/narrative for reports outside of premium? Closest i could get to end user narrative was embedding the report iframe into atlassian teams (no ms teams)

Q: How do you go about right sizing the Working Set Size for dataflows (Container Size (Mb) setting) to ensure enough parallelism of the mashup engine to run dataflows optimally?

Q: Can you please demo configuration for using PowerApps visual to update a Power BI dataset within the same PowerBi report so users can see their updates come through.

Q: is it more recommended to perform data analysis in Power BI or connecting to the model using Analyze in Excel to do it in a spreadsheet instead?

Q: What’s the best training resource for data modeling in Power BI and * schema?

Q: Are there any options for end user comments/narrative for reports outside of premium? Closest i could get to end user narrative was embedding the report iframe into atlassian teams (no ms teams)

Q: How do you go about right sizing the Working Set Size for dataflows (Container Size (Mb) setting) to ensure enough parallelism of the mashup engine to run dataflows optimally?

Q: Have you got a video coming up with how to make external tools?

Q: is it more recommended to perform data analysis in Power BI or connecting to the model using Analyze in Excel to do it in a spreadsheet instead?

Q: How do you require parameters to be entered before the report page loads?

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

Q: Is there any idea to give reply answers asked in live chat to respective questioned mail id?

Q: I stored some vector images as base 64 and stored the column as image URL. Used to display dynamic vector images as KPI using dataimage by cloudcsope, however it doesnt work anymore.Ny alternative.

Q: can Power BI show visual text annotations for certain events on a time series chart without requiring hovering over the points?

Q: Can we switch themes dynamically on a click of a button?

Q: I stack slicers vertically, and my users complain about the pop up options.. I.e. expand slicer.. are there display options that would display diff or hide even?

Q: How do you calculate totals for the last 15 days on a live data and make it dynamic such that if you select a date from a slicer it shows totals for the last 15 days from the selected date?

Q: is there any way to automate running performance analyser on a bunch of reports and save down the JSON (could something like UI flows work here?)

Q: Have you heard about anchor modelling?

Q: When Power BI Notebooks gets here, will I be able to use Python, Scala and M to build out my model?

Q: With perspectives would we lend more towards having large data models with all our data/scenarios and then exposing perspectives for specific areas/sub-domains?

Q: Are translations going to make it to Power BI road map anytime soon?