While visualizing data in Power BI Report if you wish to have any picture which is relevant to data with a filter context in the Visual (...

A Sunburst Chart is used to visualize hierarchical data, depicted by Multiple Donut Chart Layers. The circle in the center represents the...

A Common Question by many Power Beginners that how to have a Fiscal Quarter and Fiscal Year Fields on the basis of Fiscal Calendar in...

We are providing a free sample to all our registered members to access and download and try, shortly. A Complete report showing...

Why you use Excel? The answer from many Excel users is - "We create Reports / Dashboards" But the creation of reports by using Formulae...

Power Query Editor (PQE) is a best tool available in Excel / Power BI / SSAS (SQL Server Analysis Services). PQE performs the ETL...

Some times you need to deal with Data in PDF Files. And you can't compute data within PDF, so you need to take that Data into Excel /...

Learn a simple trick to combine many CSV Files in a folder to a single Query Table in Power Query Editor. In Power BI / Excel, you can...

A most common Question I face from many Participants during my Training programs that , is there a possibility to compare Excel and Power...

The question posted in community.powerbi.com Is there a SAMEPERIOD LAST DAY equivalent in DAX? Hence August 1st to 15th versus July 1st...

This is a most common question asked across the Groups. How to Hide or Un-hide Sheets based on Selection. There are two ways One, by...

Creating PowerPoint is one big task while preparing for any Special events like Monthly/Quarterly Business Performance Meetings! It is my...

Microsoft Power Query provides a powerful data import and cleansing process experience While working with Power Query in Excel and Power...

Many times I have seen a question in many forums, how to Get Data from Google Sheets Interestingly , the process is quite simple and you...

When you are developing a report in Power BI, you always need special effects to make your report much interesting and readable and also...