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

Workflow in Navision/BC 365

www.triknow.com Workflow in Navision/BC 365 Microsoft Navision BC has features of workflow, what do workflows do? Workflow Helps companies to get control of their different departments under one umbrella. It is actually a control system that checks every input before posting the same into the system. There are various types of workflow available in the system i.e. Purchase Workflow, Sales Workflow and General Ledger Workflow:- If these workflows are activated, then the user can able to create the respective documents, however, cannot post the same until his/her supervisor not approved it. In this way, every input can be controlled, and accordingly, the data can be managed. Further, Workflow enables you to design and execute business processes within the application system. For example, the approver can get the Email notification related to their department ...

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, ...

HOW TO CREATE A TRANSFER ORDER

TRIKNOW INOVATIONS LLC HOW TO CREATE A TRANSFER ORDER Setup for Transfer Order Before Creating the Transfer Order, it is required to do the following setups:- Set the Transfer order number series in Inventory Setup Transfers If your warehouse has more than one location, you can transfer items between locations. To transfer items from one location to another, you must create a transfer order. Before you can create an order you must set up an in-transit location and a transfer route. Transfer Order The transfer order is order very similar to a sales order or a purchase order. The transfer order can be created from the transfer-from or t...

Fun with Tech

Search This Blog