Drill DOWN with Hierarchy in Power BI and using Book Marks
How to use Drill Down With Hierarchy in Power BI , also use Book Marks to make the Visual Impact much Better !To know how to manipulate...
top of page
Create account
+91 96113 44773
Search
Vijay Perepa
Aug 30, 20201 min read
How to get Totals Based on Cell Color Creating / UDF (User Defined Functions) with VBA
Some times we requires some Special or Customized Functions in Excel but we may not get them. For Example if you want get Total Values,...
95 views0 comments
Vijay Perepa
Aug 29, 20201 min read
Interactive Chart with INDIRECT Function and Named Ranges
Creating Reports with Excel Charts is quite Easy and Effective. Whenever we create a Chart in Excel we need to keep in view the end...
64 views0 comments
Vijay Perepa
Aug 28, 20201 min read
Scenario Planning : Foreseeing how your big picture could change, so you can get the details right
Register Now https://valq.com/webinars/scenario-planning-foreseeing-how-your-big-picture-could-change-so-you-can-get-the-details-right/
20 views0 comments
Vijay Perepa
Aug 28, 20201 min read
One Chart Many Colors - Chart Hierarchy with Conditional Formatting (Toggle Chart)
Some time you wish you have different colors for each month and Years in a Chart where the Axis is shared by both Year and Month (Chart...
137 views0 comments
Vijay Perepa
Aug 27, 20201 min read
How to Clean Excel Workbook to avoid unused sheets
While working on Excel Files, many times due to various reasons you may find many sheets piled up containing sheets which are really not...
59 views0 comments
Vijay Perepa
Aug 27, 20201 min read
Learn DAX - TOPN - Dynamic Selection
DAX Functions give us a great Scope to get the insights from the Large Datasets. A simple functionality will allow us to get multiple...
115 views0 comments
Vijay Perepa
Aug 26, 20201 min read
How to Create Custom Tool Tip with Dynamic Image
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 (...
182 views0 comments
Vijay Perepa
Aug 26, 20201 min read
How to Create Animated SUNBURST CHART
A Sunburst Chart is used to visualize hierarchical data, depicted by Multiple Donut Chart Layers. The circle in the center represents the...
136 views0 comments
Vijay Perepa
Aug 26, 20201 min read
How to create Dynamic Date Table in Power BI
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...
102 views0 comments
Vijay Perepa
Aug 25, 20201 min read
Power BI Sample Report
We are providing a free sample to all our registered members to access and download and try, shortly. A Complete report showing...
23 views0 comments
Vijay Perepa
Aug 24, 20201 min read
How to create Complete Excel Dash Board in 15 minutes
Why you use Excel? The answer from many Excel users is - "We create Reports / Dashboards" But the creation of reports by using Formulae...
618 views2 comments
Vijay Perepa
Aug 23, 20201 min read
Understanding Power Query Editor - using Pivot / UnPivot / Transpose and many more techniques.....
Power Query Editor (PQE) is a best tool available in Excel / Power BI / SSAS (SQL Server Analysis Services). PQE performs the ETL...
296 views0 comments
Vijay Perepa
Aug 21, 20201 min read
Importing PDF Data to Power BI / Excel
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 /...
227 views0 comments
Vijay Perepa
Aug 20, 20201 min read
Combining Files in a Folder to a Single Table in Power Query Editor ( Power BI / 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...
133 views0 comments
Vijay Perepa
Aug 16, 20201 min read
Compare Excel Power BI Functions
A most common Question I face from many Participants during my Training programs that , is there a possibility to compare Excel and Power...
160 views0 comments
Vijay Perepa
Aug 15, 20201 min read
Comparing First Fortnight Revenue with 2nd Fortnight revenue (Day to Day) in a Month using DAX!
The question posted in community.powerbi.com Is there a SAMEPERIOD LAST DAY equivalent in DAX? Hence August 1st to 15th versus July 1st...
145 views0 comments
Vijay Perepa
Aug 14, 20201 min read
Hide or Un-hide sheets based on selection using VBA in Excel: A Most common question Asked in in VBA
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...
37 views0 comments
Vijay Perepa
Aug 12, 20201 min read
How to Create A Complete PowerPoint Deck - Direct from Excel Dashboard with Few Buttons (Macros)
Creating PowerPoint is one big task while preparing for any Special events like Monthly/Quarterly Business Performance Meetings! It is my...
889 views0 comments
Vijay Perepa
Aug 11, 20201 min read
Do you wish to Learn M Language (MQuery)?
Microsoft Power Query provides a powerful data import and cleansing process experience While working with Power Query in Excel and Power...
162 views1 comment
bottom of page