Calculating Fiscal Quarter in Power BI

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

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 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