Show items with no value
By default, Power BI won’t show items which do not have values. The following picture shows that Products “Apples” and[…]
Read moreAuthor: Abu Hasan
Obtain Last Working Date before Current Row Date
Assuming Working Days are from Monday to Friday, we want the following First Add a custom Column to identify day[…]
Read moreTriggering Bookmarks by Clicking Visuals
To see the bookmarks in action click any of the first 3 charts. Currently bookmarks can only be triggered by[…]
Read moreExtract Numbers/ Text only from sentences
I saw similar problem posted in Power BI Community and thought this is worthy of a postHere is the sample[…]
Read moreFunnel Chart with negative Values
Funnel chart is a beautiful chart in Power BI but if the values for a particular Group in a funnel[…]
Read moreLookup Between 2 Dates and return a corresponding Value
Lets begin with the objective (End Result) in mind In Excel we can use an Index Match Array Formula to[…]
Read moreConditional Formatting of Column and Bar Charts
Column and bar charts are arguably the most commonly used charts typically used for comparing the relative size of distinct[…]
Read moreGetting the TOP Rows per Category -DAX VS Power Query “M”
Here is the data of Top 30 tennis players in the World from 5 different Continents Our Objective is to[…]
Read moreUsing VALUE parameter in RANKX
Many of us who have used this function have rarely if ever seen the VALUE argument of RANKX function in[…]
Read moreSumIf in Power Query and Calculated Column
IN EXCEL The SumIF in Excel is pretty easy CALCULATED COLUMNS USING DAX you can use one of the following[…]
Read more