CRAZY keyboard shortcuts for DAX in Power BI Desktop
Patrick shows you how to be efficient in Power BI Desktop using keyboard shortcuts for the DAX Editor. It is crazy bananas! Documentation: https://docs.microsoft.com/power-bi/desktop-accessibility
Quickly review your Power BI Data model with VertiPaq Analyzer
Patrick shows a quick way to review your Power BI data model with VertiPaq Analyzer directly in DAX Studio.
AutoML in Power BI, DAX and Overlays… (Roundup | October 28, 2019)
[fusion_builder_container hundred_percent="no" hundred_percent_height="no" hundred_percent_height_scroll="no" hundred_percent_height_center_content="yes" equal_height_columns="no" menu_anchor="" hide_on_mobile="small-visibility,medium-visibility,large-visibility" status="published" publish_date="" class="" id="" border_size="" border_color="" border_style="solid" margin_top="" margin_bottom="" padding_top="" padding_right="" padding_bottom="" padding_left="" gradient_start_color="" gradient_end_color="" gradient_start_position="0" gradient_end_position="100" gradient_type="linear" radial_direction="center" linear_angle="180" background_color="" background_image="" background_position="center center" background_repeat="no-repeat" fade="no" background_parallax="none" enable_mobile="no" parallax_speed="0.3" background_blend_mode="none" video_mp4="" video_webm="" video_ogv="" video_url="" video_aspect_ratio="16:9" video_loop="yes" video_mute="yes" video_preview_image="" filter_hue="0" filter_saturation="100" filter_brightness="100" filter_contrast="100" filter_invert="0" filter_sepia="0" filter_opacity="100" filter_blur="0" filter_hue_hover="0" [...]
Use Microsoft Flow, and other options, to refresh your Power BI dataset
Adam looks at your refresh options for Power BI datasets. Including Microsoft Flow! https://powerbi.microsoft.com/en-us/blog/refresh-your-power-bi-dataset-using-microsoft-flow/
Remove CONFUSION in your Power BI report with this little feature
Patrick shows you a little known Power BI feature to help your report consumers use every bit of your report. Removing confusion and maximizing use!
One little change to improve Power BI slicer performance (BANANAS!!!)
Patrick shows how you can make one little change to your Power BI slicers to improve report performance. It's bananas!
Worst pie chart ever in Power BI & swords (Roundup | October 21, 2019)
[fusion_builder_container hundred_percent="no" hundred_percent_height="no" hundred_percent_height_scroll="no" hundred_percent_height_center_content="yes" equal_height_columns="no" menu_anchor="" hide_on_mobile="small-visibility,medium-visibility,large-visibility" status="published" publish_date="" class="" id="" border_size="" border_color="" border_style="solid" margin_top="" margin_bottom="" padding_top="" padding_right="" padding_bottom="" padding_left="" gradient_start_color="" gradient_end_color="" gradient_start_position="0" gradient_end_position="100" gradient_type="linear" radial_direction="center" linear_angle="180" background_color="" background_image="" background_position="center center" background_repeat="no-repeat" fade="no" background_parallax="none" enable_mobile="no" parallax_speed="0.3" background_blend_mode="none" video_mp4="" video_webm="" video_ogv="" video_url="" video_aspect_ratio="16:9" video_loop="yes" video_mute="yes" video_preview_image="" filter_hue="0" filter_saturation="100" filter_brightness="100" filter_contrast="100" filter_invert="0" filter_sepia="0" filter_opacity="100" filter_blur="0" filter_hue_hover="0" [...]
Power BI: Case of the unexplained date (LastDate in DAX)
Adam looks at why the LastDate DAX function is returning the wrong date within Power BI Desktop. Breaking down a twitter conversation. Twitter thread: https://twitter.com/dhawalmehta/status/1183750809646972929 Marco's Blog: https://www.sqlbi.com/articles/semi-additive-measures-in-dax/ Reza's Blog: https://radacad.com/lost-customers-dax-calculation-for-power-bi Calendar Table: https://www.youtube.com/watch?v=gyvhM5eiT0U Reduce data model size: https://www.youtube.com/watch?v=c-ZqToc85Yc Sample download
Ask a question with the new Q&A visual in Power BI Desktop
Justyna joins us to show the new Q&A visual in Power BI Desktop. Easily ask a question and tune results in this awesome update. Connect with Justyna: Twitter: https://twitter.com/JustynaLucznik
Looking at the Lineage View in Power BI (October 2019)
Adam shows how to use the lineage view within Power BI. Quickly see what data sources are being used by your dashboards and reports.