Getting a simple bookmark button pair working together is easy in Power BI. Here is how you do it. In this, we discuss how to use, Button to hide a simple object. Let’s try with a simple object and a button. When the user clicks the button, the square object hides and when clicked again
Tag: Power BI Desktop
In this post, we are going to find out how to, Getting the previous 12 months (or any number of months) is a pretty common requirement in Power BI dashboards. A simple measure would do that. But what if the dataset is missing data from this month or a few months from the current month?
This is the 2nd post of the Excel-to-Power BI series and in this post, we gonna discuss how to count with condition or perform a COUNTIF( ) in Power BI. Is there a COUNTIF in Power BI No. COUNTIF is not directly available to use in Power BI. However we can do count with condition/conditions
In post one & post two of the PARALLELPERIOD series, I talked about how to use PARALLELPERIOD to calculate values from a previous time period and select the time period name from a slicer. Part 1 – Calculate Previous Month In Power BI |PARALLELPERIOD Function Part 2 – Select PARALLELPERIOD Interval Name From A Slicer
In post one of the PARALLELPERIOD series, I talked about how to use PARALLELPERIOD to calculate values from a previous time period. Previous post – Calculate Previous Month in Power BI |PARALLELPERIOD function. – overbeeps Next post – Select PARALLELPERIOD number of intervals from a slicer – overbeeps In this post, I’m going to show
How to show Top N in a Power BI bar chart
Showing Top N things (Top 5 products, Top 10 songs, Best 3 Employee, Fastest Player, etc) is really effective when getting insights from a Power BI report. In this post let’s see how Power BI Top N filter works with some examples. Example 1 – Get Top N using the filter pane Dataset We’re going
How to show/hide images based on the selection in Power BI
In this post, let’s discuss how to show/hide visuals based on selection. Requirement I have a dataset from project management software. It has details of tasks, task status and person to whom the task is assigned, etc. I need to create a report with user control to select an assignee and display the assignee image
There are different ways to show/hide an object on the Power BI canvas base on user input, conditions, values, etc. This is the first post of a series of posts that describes different methods to do that for different use cases. In this post, we are going to discuss how to show/hide an object using
How to Filter Across Report Pages | Power BI Drillthrough & Power BI Sync Slicer
Most Power BI reports consist of 2 types of pages. Pages that have an overview of data and the other type has details of the data. For these types of reports, the user has to go through all pages with the same filters applied to all pages from the overview page. Some users need to
What is Multi Raw card visual in Power BI Some Power BI reports need to show a group of important numbers or texts in big size and dynamically changes and interact with other visuals well. The multi raw card is used to do just that. How to use Card visual in Power BI – overbeeps