Welcome to Excel Jet Consult blog post and Happy New Year 2020. In this post, we want to learn how to use the new Workbook Statistics made available to Office 365 users. Let’s get started The Workbook Statistics is in the Proofing group of the Review tab. The Workbook Statistics gives a summary count of cells, formulas, charts, tables, PivotTables, […]
Continue reading
Apply Custom Conditional Formatting to Clustered Column Chart in Power BI
Welcome to Excel Jet Consult blog post. In this tutorial, we will see how to apply custom conditional formatting to column chart visual. Conditional formatting enables users to easily spot trends and patterns in our data using colors, icons and bars Column Chart Conditional Formatting For this example, we want to see Sum of Amount by Month. Note, Sum of […]
Continue reading
New Quarter DAX Time Intelligence Function
Welcome to Excel Jet Consult blog post. In this tutorial, we want to learn various methods we can use to calculate standard Quarter and how to create using the new Quarter DAX function released in the Microsoft Power BI Desktop December 2019 updates. Let’s get started To use the new Quarter DAX function, we must create a calendar table because […]
Continue reading
Fixing Improper Dates in Power Query
Welcome to Excel Jet Consult blog post. In this tutorial, I will share with us how to solve the problem of improper date in Power Query. Let’s get started Quite often, I do get questions from people who have challenge of working with dataset that wasn’t correctly entered on Excel. Hence, I write this blog post to address the problem. […]
Continue reading
Advanced Filtering Within Range of Dates
Welcome to Excel Jet Consult blog post. In this tutorial, we want to learn how to use the WHERE clause to filter between two dates. Let’s get started. In the caption below, we have the 2017 Data table fetched from our Transaction Records database We want to retrieve Product, Account Manager, Order Priority, Total Revenue from the Sales Data between […]
Continue reading
Amazing New Zebra BI Charts and Tables in Power BI
Welcome to Excel Jet Consult blog post. In this video, I talked about how to use the new Zebra BI Charts and Tables made available in Microsoft Power BI December 2019 updates courtesy of Andrej Lapajne and his team!
Continue reading
New Shape Map Visual in Power BI
Welcome to Excel Jet Consult blog post. In this tutorial, we want to see how to use the new Shape Map available in Power BI November 2019 update and onward. Let’s get started The Shape Map allows users to display relative comparisons of States, Provinces and Regions on a map using colors. The Show Map visual needs to be activated […]
Continue reading
Activating Decomposition Tree Visual & Artificial Intelligence Insights
Welcome to Excel Jet Consult. In this blog post, we will talk about how to activate Decomposition Tree visual and AI Capabilities in Power BI made available in November 2019 Power BI update onward. To activate Decomposition Tree visual and AI capabilities: In the File tab, select Options and settings. Further select Options In the Options dialogue box, under Global, […]
Continue reading
Enabling New Updated Ribbon
Welcome to Excel Jet Consult. In this blog post, we will talk about how to enable the new updated ribbon made available in November 2019 Power BI update. The new updated ribbon is typical of the ribbon tab in Excel In the caption below, we can see the old ribbon tab To enable the Updated Ribbon: In the File tab, […]
Continue reading
Decomposition Tree Visual, AI & New Formatting in Power BI
Welcome to Excel Jet Consult blog post. In this tutorial, we want to see how to use the new Decomposition Tree visualization that debuts in November 2019 Power BI update. Let’s get started Decomposition Tree allows user to visualize data across spectrum of dimensions. In a simpler term, the visual allows users to break down a group to see its […]
Continue reading