Power BI Top/Bottom N Filters

To calculate the Top-performing records, power BI has some basic functionality i.e. Rank Function (DAX) and Top N calculation (Filter visual option). In this article, we will go through the second option (Filter visual option).

This option has both calculations i.e. Top N and Bottom N Numbers, let learn the same through below example where store wise sales have been represented by 'line and stacked column' chart.

However, by using the Top N filter option, the top sales number as per stores can be filtered. For this please use filter option available under filters section as showing below:-

Now, the user can put the desired number against the Show Item as appearing in the below screenshot.

Afterwards, drag the sales amount value in By Value column and then click on "Apply Filter" as showing below:-

After clicking on the "Apply Filter" the visual will start to show the values according to filters,

In Next article we will do the same by Rank Option.

Comments

Adjust Exchange Rates – NAVISION, BC 365

Adjust Exchange Rates – NAVISION, BC 365 As per accounting standard, we need to present the balance sheet in their true and fair value with considering the other accounting concepts; Adjust exchange rate function helps us to do the same considering the different currencies. In multinational companies, the transactions take effects in many currencies, as well as the currencies, need to be evaluated as per their closing averages (Currency exchange rate) of the year and accordingly the Unrealized FX Gains/loss need to reflect in the balance sheet. Adjust Exchange rate, ...

Microsoft BC 365 Service Module – Introduction

Microsoft BC 365 Service Module – Introduction In this blog, I tried to explain the service module available in the Dynamics NAV/BC-365. Navision has two formats to do the service management, the first is through service quote to service invoice and the second is through a service contract. Service Management Service Quote Service order Service Invoice with Items, Labor and GL Service Credit Memo Service Management through Contract Service Contract Service Invoice period Service Contract Sign and Locked Service Item Service Invoice Service Combine Invoice Service invoice Accrual entries Service Credit Memo Service Management Service Management:- Dynamic Navision has many modules i.e. Finance, Manufacturing, Purchase, Sales, warehouse management, and Service Management. Service the modu...

Reporting currency in Navision & BC 365

Reporting currency in Navision & BC 365 In Business central 365, the values can be recorded in local currency as well as in reporting currency. In multinational business, we generally need to maintain the transactions in local currency as well as in HO currency also. Suppose, an MNC has business in India, UAE, and the USA, in this case, the transactions related to respective countries need to maintain in INR, AED, and USD, whereas the reporting currency needs to maintain in USD only. BC 365 has provision for this, in General Ledger setup user can do the setup related to local currency as well as reporting currency. For better understanding, I have taken the screenshot from BC 365 General Ledger setup which s as follow:- As highlighted, we have LCY (Local Currency) as well as Additional Reporting Currency in General Ledger setup. As per the example given above, the system can maintain transactions in local currency and can convert the same in Add...

Fun with Tech

Search This Blog