Overloading data to show as an in-visual drill down will impact performance. Consider using a separate page instead.

The Aimplan Planning & Reporting Visual allows users to see the underlying data of a cell through the context menu. This is useful for debugging or for giving advanced users a glimpse at what they are working with.

To see underlying data, simply right-click on a value cell and select "Show Data". This option is always available in the "Preview" mode of the designer, but for end users it has to be explicitly enabled.

To enable end users to access this menu, navigate to visual settings.  Then in the "End User Drill Columns" dropdown, select the columns that should be visible to the end user when they press "Show Data".

Learn how to improve the performance of your Aimplan Planning & Reporting Visual by avoiding data overload in the visual drill down. Optimize your reporting by utilizing the "Show Data" option to view underlying data through the context menu. Enable this 

Preventing Editing of a Certain Value Using a DAX Measure

Show Underlying Data to End Users

Limit Rows

Expand Rows With Checkboxes

Expand Rows Using Data Input Table

Expand Rows

Limit/Expand Number of Rows in Your Visual

Aimplan

Introduction

Signing up and the creation of a new Aimplan Instance

Welcome to Aimplan!

Login to the portal

Users

Measures

Scenarios

Storage Tables

Data Import

Creating a Process

Define Statuses

Creating a Sub-Process

Processes

Organization and Categories

Audit Columns

Companies

Other Portal Options

Resolving the "Approval Required" Message While Logging Into Aimplan

Untitled

Administration Portal

Context Menu

Top-Down Allocation

Relative Value Changes

The Aimplan data model

Convert report to planning

Step-by-step Reporting

Filtering values in sections

Using Year-to-Date Calculations

Customizing values using calculations

Value Settings

Cell Comments

Row Comments

Allocate Based on Other Value

Enable suggestions from another value

Adding comments on aggregated rows

This visual does not support exporting.

Unable to find field "Sum of Value"

Error exporting contents from visual

Chequered Pattern in Cells

Planning and Reporting Visual

Updated By & Updated At

Authentication Failed

Edit properties

Defining the Process

Creating a Storage Table

Set up Processes and Sub-Processes

Add Tables and Relationships in Power BI

Design Visual

Rules for Statuses

Using Status Visual to Lock Planning Visual

Setting up the Status Visual

Troubleshooting

Status Visual

Objectives

Adding the visual to a report

Visual Settings

Field settings

Edit Settings

Filter Data Using Slicers

Publish the Data Input Table

Auditing

Triggers

Data Input Table

Adding an Aimplan visual to Power BI

Connecting to Aimplan Data

Controlling Data Access

Aimplan User Key configuration

Create a DateIntKey

Configure editable write-back measures in Power BI

Creating a 'distinct' dropdown table

Combining actuals with planning values and have measures on row

Showing Actuals & Plan values on Rows

DAX Cookbook

Boolean measure returning false for blanks

Keeping a Semantic Model Warm

Error fetching data for this visual

Login failed for user '<token-identified principal>'

Cannot open server 'aimplan-sqlne' requested by the login

Power BI

Entra ID

Events

Firewall and Network Requirements for Azure SQL Database Access

Aimplan for SQL database in Fabric

Customer managed Azure SQL

Other information

Portal Overview

1. Base setup

2.1 Planning & Reporting Table

2.2 Editable Planning and Reporting Visual

3. Audit trail

4. Data Input Table

5. Status Visual

6. Comment Visual

Aimplan Training

Portal

2024 Q1

2024 Q2

2024 Q3

2024 Q4

Feature Updates

Do's and Don'ts

Multi Company Solution

Filter Rows Using Calculation Groups

Model Architecture

Planning & Reporting Visual

Show Underlying Data to End Users

Accessing the Show Data Menu

Remarks