PowerBI.tips

Tag: Videos

  • Data Table Filters

    Data Table Filters

    Hands down best feature this year to date, Data Table Filtering!  In the June 2018 Power BI Desktop Microsoft released the ability for you to navigate to the Data Table view.  While on this view drop down icons now appear which enable filtering of the Data Table.  This is super helpful when looking at the raw data that has been loaded into your data model.  Check out the video below to see how the feature works.

    Other Thoughts:

    For those of you who like Excel, and data tables in Excel, this feature will make you feel right at home within a pivot table type feel.  I hope you enjoy this month’s update as much as I did.  Thanks for stopping by.

    For the official documentation from Microsoft follow this link to the blog announcement.

    If you like the content generated from PowerBI.Tips please follow me on all the social outlets to stay up to date on all the latest features and free tutorials.

    Subscribe to me on YouTube.  Or follow me on the social channels, Twitter and LinkedIn where I will post all the announcements for new tutorials and content.

    YouTube Linkedin Twitter
  • When to Use Publish to Web

    When to Use Publish to Web

    There are often questions surrounding Publish to Web.  What is it?  How can I use it to share my reports?  This video walks through the proper usage for Publish to Web and how to manage the Power BI tenant settings.

    Check out this video explaining the full details surrounding this topic:

    If you like this video please be sure to follow me on Twitter, LinkedIn and be sure to subscribe to the PowerBI.Tips YouTube channel.

  • New Layout – Splash o Red

    New Layout – Splash o Red

    First off, let me say WOW!  The announcement of Layouts was well received by the Power BI Community.  Thank you so much for the positive feedback.  So much so, that I got excited and developed another Layout, Splash o Red.

    This new layout is called contains two pages.  It uses the drill through feature to navigate from the main page to the sub page.  The demo below shows you how it works.  I hope you enjoy this new layout, you can download it here.

    To see how to load data into the Layouts check out the following video below.  It will guide you through the process.  Additionally, each layout download will contain an instructions sheet just in case.

    You can check out all the layouts here.

    [products columns=”4″ category=”Layouts”]

  • Power BI September 2017 Release

    Power BI September 2017 Release

    September is here and there is a new update for Power BI desktop!  I’m so excited for this month’s update as there are many solid features.  One of the more anticipated features, Drillthrough.  This allows a user to right click on items in a table and drill to more detailed pages within the report with applied filters specific to the user’s need.  This feature was initially announced at the 2017 Data Insight’s summit.

    Another feature that is definitely worth checking out is the ability to now create more detailed themes for a report.  More of the properties of a visual are now being exposed in the JSON format for themes.  For people who do a lot of customizing of visuals this is a huge time saver.  PowerBI.Tips has provided a tool to assist you with generating your own report themes.  Click the image below to go to the improved Report Theme Generator.

    For the full details about the September 2017 release check out the blog post from Microsoft.

     

  • Power BI August 2017 Release

    Power BI August 2017 Release

    I love these updates, it’s like Christmas comes every month!!  This month we get a ton of really great features, I for one am super pumped to get into the tool and checking it out.

    Here are a couple of highlights you should check out.  First up, matrix & tables now support conditional formatting for TEXT!!!  Definitely long over due, but I’m happy it’s here.  In one of my recent projects we had a horrible time trying to get the subtotals working correctly in the matrix visual.  So much so that we had to abandon the matrix view all together.  Now it looks like with this months update there is a substantial improvement to how subtotals work.

    Lastly, I think the most important update and I think the best feature for this month’s update What-if Parameters…  I haven’t played with this much, but from what I know this is going to be awesome!  I would be willing to be the heavy analyst is going to love this feature.

    Here is the full video of all the updates for this August, Enjoy.

     

    If you want to review the full August release for PowerBI Desktop, you can hit the PowerBI Blog here.

  • Microsoft Data Insights Summit

    Microsoft Data Insights Summit

    This year I had the wonderful privilege to attend the Microsoft Data Insights summit for 2017 as a speaker.  My topic was the Top Ten Tutorials from PowerBI.Tips.  So, let me say thank you to all those who attended you provided a very fun audience and were very positive, Thanks.   For those of you who couldn’t make it to the Data Insights Summit below is the actual talk:

     

    We went through 10 different tutorials in 50 minutes.  Needless to say we went pretty quick.  So, if you were there, or just want to go through the tutorials on your own here is the list of the Top Ten Tutorials.

    10. Loading Data From a Folder ( Link to Tutorial )

    9. Using Parameters ( Link to Tutorial )

    8. Loading Multiple Excel Files ( Link to Tutorial )

    7. Custom Date Tables ( Link to Tutorial )

    6. Percent Change ( Link to Tutorial )

    5. Histograms & Disassociated Tables ( Link to Tutorial )

    4. Bar and Whisker Plot in R ( Link to Tutorial )

    3. Bar, Scatter, and Area Chart in R ( Link to Tutorial )

    2. HEX Bin Scatter Plot in R ( Link to Tutorial )

    1. Color Theme Generator ( Link to Tutorial, Link to Advanced Color Theme Generator )

     

    If you wan to learn more about Power BI or DAX follow this Link to books and other helpful Power BI resources.

  • Power BI June 2017 Release

    Power BI June 2017 Release

    This month we have a big release for Power BI Desktop and for the Power BI service.  There are a number of great new features.  For the everyday user you will love the new Data bars for the new table & matrix visualizations.  For me this really feels like a feature that is making tables and the matrix views feel more like the pivot table and formatting that can be done in excel.  Great Job Microsoft!

    For the developer who want to who may be using Rest APIs you should definitely check out the newly added feature called Custom Data Connectors.  There was an announcement last month which now opens up the world for developers to write custom connectors right in Visual Studio.

    The full June release is described in the video below:

    For the full blog write up hit this link.

    For more details about the custom data connector follow these links for more resources:

    Data Connectors GitHub repo

    Data Connector technical reference

    M Library functions

    M Language specification

  • Power BI May 2017 Release

    Power BI May 2017 Release

    It’s that exciting time of month again.  Time for another power BI desktop release.  This month here are a couple of good highlights you should check out.

    1. First up enhanced tables with word wrapping in both headers and table rows.  Woot Woot, I have really needed this feature!
    2. Clicking a row in the table will now allow filtering in other visuals.  Similar functionality to the matrix features that we already saw last month.
    3. Enhanced URL links for tables.  This on is interesting.  If you are an ad agency you should really pay attention to this one.  This allows you to embed a mailto command directly in a table.  Then you can click the link to send an email to someone directly from Power BI, perfect for following with a sales leads.
    4. Combo charts label density.  This feature is one I can really stand behind. Frankly, I didn’t know I needed it, but now that I have seen the light, this will be awesome.

    For the full Power BI Desktop release here is the full announcement.

    If you want to watch the full video for the release you can see the full video below:

    Download the latest release of Power BI Desktop here.

  • Power BI April 2017 Release

    Power BI April 2017 Release

    With another month comes another exciting release of PowerBI desktop.  This month we have a number of really interesting features releases.  One of the more interesting feature releases you should definitely check out is the Add Column by Example.  I have seen a demo of this feature and can definitely see the potential for speeding up the data cleansing process in the query editor.  I’ve also included the YouTube video below for this feature.

    To read about the full release from Microsoft hit the link here.

    The April 2017 Update:

     

    Check out the Add Column by Example demo:

    For other great Power BI videos click the image below:

    PBI Videos

  • Power BI Using Multiple User Accounts

    Power BI Using Multiple User Accounts

    Here is a super helpful video from Guy in a Cube about how to have multiple logins using Google Chrome.  Often I find my self juggling between a work account and my PowerBI.Tips accounts to test out various Power BI features.  This little trick definitely saves you time and headache when jumping between accounts.

    Side note: I also found this great technique works on Azure (portal.azure.com) if you frequent this site for work and for your other adventures.  

    This topic was originally talked about via James Callaghan and the Chris Webb’s Blog.

    Google talks about multiple logins here.  If you don’t already have google chrome you can download it here.

    Use multiple accounts in chrome:

    If you haven’t already make sure you go check out Adam’s site and YouTube Blog for more great information.

    For more great videos about Power BI click the image below:

    PBI Videos