Drill-through is an option in power bi desktop using which we can drill through to a page having details with a specific context. After the March 2020 update, Drill through can be performed using the button as well, earlier the same task was performed by right-clicking on a context in a chart and then selecting…
Power Automate is an RPA solution from Microsoft which is also part of the Power Platform. Microsoft Power Platform is a group of products i.e Power BI, Power Apps, Power Virtual Agent, and Power Automate. Microsoft Power Automate was earlier known as Microsoft Flow. Using power automate, a large number of business automation tasks can…
In this article, we will discuss dynamic multiple-column selection using a slicer and a button in Microsoft Power BI. Here, we will use the new page navigation option which is provided the action property of the button. Page Navigation in action property is available from Power BI March 2020 update. We have already explained in…
Page Navigation is an important part of the report as it makes the report more interactive. Previously, We used to achieve page navigation in a report using a bookmark and it was not possible to do the same using slicers and a button. After the March 2020 Power BI Update, It is possible to…
Working on data from the latest file in a folder is a very common requirement. I have been asked about it in one of the Company Interviews. Well, at that moment of time I was having no idea about it but later I got this as a requirement in one of my project requirements. So, How…
I recently worked upon a scenario where I have shown all the selected values in slicer in a Card. So, Card basically acts as a display screen which shows all the selected values in the slicer. The scenario which I just mentioned is very relevant and practical from reporting perspective with an intention to show…
Microsoft Power BI is the most demanding analytics tool in the market. As per Gartner`s Magic Quadrant for Analytics and Business Analytics Platform 2022, Microsoft Power B is the leader in the segment. You can check out the last 5 years of Gartner magic quadrant ranking for analytics and business analytics platforms to see how…
Today, I updated Microsoft Power BI on my machine and found something amazing which I would like to share with you. We always try very hard to make our Power BI Report look appealing and nice. For achieving that we use to make a layout using Microsoft PowerPoint and then upload it in PowerBI, especially…
I was sitting here in my home thinking about what to write for my next article on my blog. I thought about what could be most helpful for my readers. When I was in my initial learning days I found that DAX is the most important language in PowerBI. With the help of DAX, you…
I was solving a problem on Microsoft Power BI Community which proved to be the best use case for LOOKUPVALUE function in PowerBI. So finally, I decided that I will write a blog about it so that my readers understand where and how to use the LOOKUP VALUE Function in PowerBI. What is the LOOKUPVALUE…