Year: 2021
Power BI > Using slicer for just highlighting values without filtering
Inkey, December 20, 202110501 Views
The general purpose of slicer visual in Power BI is to filter the data points in the report and view only the filtered information. They provide options (single or multiple) to a user, to click on & filter the visuals on the page. Recently, in one of our projects, we were tasked with a requirement to highlight the bars of a bar chart instead of filtering the visual based on the selected value of the slicer. It sounded odd at first […]
Read morePower BI > Drill-through feature from Card visual
Inkey, November 19, 202118137 Views
In Power BI, a drill–through feature permits the report consumer to peer detailed facts associated with the primary page in the context of a particular data point applied. With drill via Power BI reports, one can create a detailed report page on your data that focuses on a particular applied data point. When the readers want to analyze a particular record or data […]
Read moreDynamics 365 Sales data import. Anomalous materials and unforeseen consequences
Inkey, October 28, 20211279 Views
We all have imported data into CRM at some point in our life. And a part of the process of importing data is cleaning up the data the is to be imported. I am sure almost all of us have encountered some unusual data that we had to clean up and some unusual data that looks […]
Read morePower BI > How to filter all the data by TODAY, by default?
Inkey, September 10, 202121227 Views
Ever wondered how we can filter the Power BI report to show only Today’s data by default but at the same time give the flexibility to change the Date filter? The approach we as developers generally take is – create a calculated column IsToday in the Calendar table and have it return “Yes” for today’s […]
Read moreLoad metadata of all entities and get Object Type Code based on Entity name in Dynamics 365 for Sales.
Inkey, August 12, 20214477 Views
In this blog I’ll be taking you over how to get the Object type Code for the particular entity based on the Entity name. Suppose we need to get object type code for different entities in a loop in an stand alone .Net application. Generally, people are writing a fetch into the loop but not […]
Read moreUpdating the SQL DataSource from Power BI using Power Automate Visual
Inkey, August 6, 20217117 Views
Ever thought of manipulating the data in your SQL data source directly from the Power BI Report? If yes, our prayers have been heard (as the use of Power Automate within Power BI is still in Preview as of writing this blog) and will be answered soon (when made GA)! An exciting new feature was […]
Read moreLatest Updates in Business Central V 18.3
Inkey, August 5, 20212424 Views
Description This blog will describe the updates on Business Central 18.3. Below is the list of the major updates available in Dynamics 365 Business Central. Document Objective G/L Entry Dimension Correction. Inventory Documents. Item Availability by Lot No. Variant codes on production orders in Business Central. In this blog we are going to discuss some […]
Read moreSchema Update Mode in AL code for Dynamics 365 Business Central
Inkey, July 23, 20218818 Views
Description: This blog will describe the significance of the Schema Update Mode and why it is used in Business Central. We were facing some issues while working on the table extensions and realized that we could not change the data type or the size of the custom fields we described in the extension once published. […]
Read moreCalculation Groups in Tabular Editor
Inkey, June 11, 20214603 Views
Consider a scenario where your measure’s definitions are the same but the only difference is the base measures. For example, while doing time-related calculations like MTD, YTD, QTD for 3 different calculations/measures, we need to create 3 measures for MTD, 3 measures for YTD, and 3 measures for QTD, resulting in total 9 measures such […]
Read moreCreate and Configure model-driven app interactive experience dashboards
Inkey, June 10, 202110868 Views
In this blog I will show you how to create and configure Interactive experience dashboards in model driven apps. The Interactive dashboards are fully configurable and security-role based and deliver information across multiple streams in real time. The Interactive dashboards have two forms: multi-stream and single-stream. Multi-Stream dashboards can be table-specific dashboards. The multi-stream dashboards […]
Read more
