top of page
Search


𝐃𝐞𝐞𝐩 𝐃𝐢𝐯𝐞 𝐞𝐢𝐭𝐡𝐞𝐫 𝐰𝐢𝐭𝐡 𝐃𝐀𝐗 𝐨𝐫 𝐉𝐮𝐬𝐭 𝐰𝐢𝐭𝐡 𝐑𝐢𝐠𝐡𝐭 𝐌𝐨𝐮𝐬𝐞 𝐂𝐥𝐢𝐜
One of the best feature available with Power BI Since beginning. To know watch this Video

Vijay Perepa
Oct 6, 20211 min read

Vijay Perepa
Sep 28, 20210 min read



Vijay Perepa
Sep 4, 20210 min read


𝐂𝐢𝐫𝐜𝐥𝐞 𝐏𝐨𝐥𝐚𝐫 𝐕𝐢𝐬𝐮𝐚𝐥𝐬 𝐢𝐧 𝐏𝐨𝐰𝐞𝐫 𝐁𝐈 𝐮𝐬𝐢𝐧𝐠 𝐑 𝐕𝐢𝐬𝐮𝐚𝐥𝐬
Tried using Polar Char in place of Pie/Donut Chart to show case the data of multiple variables. Pie / Donut don't support both positive...

Vijay Perepa
Aug 11, 20211 min read


𝐇𝐨𝐰 𝐭𝐨 𝐮𝐬𝐞 𝐑 𝐕𝐢𝐬𝐮𝐚𝐥𝐬 𝐢𝐧 𝐏𝐨𝐰𝐞𝐫 𝐁𝐈
A Simple Column chart using R Visuals in Power BI. R is a language and environment for statistical computing and graphics and it is...

Vijay Perepa
Aug 4, 20211 min read


𝐏𝐨𝐰𝐞𝐫 𝐁𝐈 - 𝐂𝐨𝐦𝐩𝐨𝐮𝐧𝐝 𝐀𝐧𝐧𝐮𝐚𝐥 𝐆𝐫𝐨𝐰𝐭𝐡 𝐑𝐚𝐭𝐞
#CAGR#PowerBi# Dax Dynamic Compound Annual Growth Rate (CAGR) in Power BI. Tutorial will be published shortly! Also covering many...

Vijay Perepa
Jul 11, 20211 min read


𝐀𝐧𝐢𝐦𝐚𝐭𝐞 𝐂𝐡𝐚𝐫𝐭𝐬 𝐢𝐧 𝐄𝐱𝐜𝐞𝐥 | 𝐓𝐮𝐭𝐨𝐫𝐢𝐚𝐥 𝐒𝐡𝐨𝐫𝐭𝐥𝐲
Using small piece of code you can animated Charts in Excel like you can do in Power Point TUTORIAL WILL BE POSTED SHORTLY ! Keep watching...

Vijay Perepa
Jul 5, 20211 min read


Learn Excel VBA Hiding Objects and Charts in A spreadsheet
Learning VBA is very helpful to automate certain activities may be they are simple or complex. In this Video I have shown how to Show or...

Vijay Perepa
Jun 28, 20211 min read


𝐏𝐨𝐰𝐞𝐫 𝐁𝐈 - 𝐉𝐮𝐧𝐞 𝟐𝟎𝟐𝟏 𝐔𝐩𝐝𝐚𝐭𝐞𝐬 - 𝐅𝐞𝐰 𝐢𝐦𝐩𝐨𝐫𝐭𝐚𝐧𝐭 𝐏𝐨𝐢𝐧𝐭𝐬
June 2021 update of Power BI is out. Few very important points Reporting options: Paginated Report Visual in Power BI Desktop (Preview)...

Vijay Perepa
Jun 26, 20211 min read


Power BI Webinar
Link to the Webinar : MS Teams

Vijay Perepa
Jun 25, 20211 min read


𝐄𝐱𝐜𝐞𝐥 𝐕𝐁𝐀 𝐂𝐨𝐥𝐮𝐦𝐧 𝐀𝐮𝐭𝐨 𝐖𝐢𝐝𝐭𝐡 𝐉𝐮𝐬𝐭 𝐛𝐲 𝐬𝐞𝐥𝐞𝐜𝐭𝐢𝐧𝐠 𝐂𝐞𝐥𝐥
Few Excel habits are Die Hard and Some times they are going to hamper your productivity. While entering Data in Excel , Majorly when you...

Vijay Perepa
Jun 24, 20211 min read

Vijay Perepa
Jun 17, 20210 min read



Vijay Perepa
Jun 2, 20210 min read


For Power BI Learners - What should be the approach!
𝗡𝗼𝘁𝗲: 𝗠𝘆 𝗥𝗲𝗾𝘂𝗲𝘀𝘁 𝘁𝗼 𝘁𝗵𝗲 𝗿𝗲𝗮𝗱𝗲𝗿𝘀 𝘁𝗼 𝘁𝗮𝗸𝗲 𝘁𝗵𝗶𝘀 𝗮𝘀 𝗮 𝗳𝗲𝗲𝗱𝗯𝗮𝗰𝗸 𝗼𝗻𝗹𝘆! 𝗔𝗻𝘆...

Vijay Perepa
May 15, 20212 min read


𝐂𝐨𝐧𝐝𝐢𝐭𝐢𝐨𝐧𝐚𝐥 𝐂𝐚𝐫𝐝 𝐕𝐢𝐬𝐮𝐚𝐥𝐬 - 𝐏𝐨𝐰𝐞𝐫 𝐁𝐈
While dealing with YoY comparisons and Cards, you may require flexibility to show the values based on selection and other conditions. In...

Vijay Perepa
May 11, 20211 min read


𝐂𝐡𝐚𝐫𝐭𝐢𝐜𝐮𝐥𝐚𝐫 + 𝐏𝐨𝐰𝐞𝐫 𝐁𝐈 = 𝐂𝐮𝐬𝐭𝐨𝐦 𝐕𝐢𝐬𝐮𝐚𝐥𝐬
𝐏𝐨𝐰𝐞𝐫 𝐁𝐈 𝐓𝐨𝐩 𝟓 𝐏𝐫𝐨𝐟𝐢𝐭𝐚𝐛𝐥𝐞 𝐚𝐧𝐝 𝐋𝐨𝐬𝐬 𝐌𝐚𝐤𝐢𝐧𝐠 𝐁𝐫𝐚𝐧𝐜𝐡𝐞𝐬 𝐮𝐬𝐢𝐧𝐠 𝐂𝐡𝐚𝐫𝐭𝐢𝐜𝐮𝐥𝐚𝐭𝐨𝐫...

Vijay Perepa
Apr 25, 20211 min read


There is only one action which doesn't have straight Key Board Short Cut in Excel.
Do you know what is that? And you wish to create your own Short Cut using a single VBA Statement Application.CommandbarsApplication.Comma...

Vijay Perepa
Apr 24, 20211 min read



Vijay Perepa
Apr 23, 20210 min read


Know All Functions in Power Query ( M Language)
Get the complete list of Functions available in M Language with small step. Coming up with a new series of Videos . To get notified...

Vijay Perepa
Apr 21, 20211 min read


𝗖𝗮𝗻 𝗘𝘅𝗰𝗲𝗹 𝗣𝗿𝗲𝘀𝗲𝗻𝘁 & 𝗘𝘅𝗽𝗹𝗮𝗶𝗻 𝘁𝗵𝗲 𝗗𝗮𝘁𝗮 𝗹𝗶𝗸𝗲 𝘄𝗲 𝗱𝗼?
Imagine if Excel started Talking to you and present the Data and Charts and also giving explanation about the Data, and there is less...

Vijay Perepa
Apr 13, 20211 min read
bottom of page
