Welcome to Excel Jet Consult blog post. In this video tutorial, I demonstrated how to use the Power BI Play Axis Dynamic Slicer custom video.

Welcome to Excel Jet Consult blog post. In this tutorial, we want to learn how to calculate Fiscal Quarter. Let’s get started. To learn how to create Standard Quarter using different methods, click here Fiscal Quarter In this example, the Fiscal Quarter starts from July of the current year and ends in June of the next year. This invariably implies […]

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 […]

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 […]

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!

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 […]

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, […]

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, […]