Project

General

Profile

Actions
Copy link

Bug #894

open

Boolean data type shows incorrect aggregation functions compared to Power BI

Added by Maryam Farooq 3 months ago. Updated 22 days ago.

Status:
Waiting for Regression
Priority:
High
Assignee:
ALi RAZA
Target version:
-
Start date:
01/29/2026
Due date:
% Done:

100%

Estimated time:
Spent time:
5:30 h

Description

Bug Description

When a Boolean data type field is used in Prism, the available aggregation options do not align with standard BI behavior or Power BI results.

In Power BI, Boolean fields support only Count and Count Distinct aggregation functions. However, in Prism, all aggregation functions (SUM, AVG, MIN, MAX, etc.) are displayed for Boolean data types, which leads to incorrect or misleading aggregation options for users.

This inconsistency can cause confusion and incorrect visualization or summary results when working with Boolean fields.

Actual Result

Prism displays all aggregation functions for Boolean data type fields.

Aggregation options such as SUM, AVG, MIN, MAX are selectable for Boolean fields.

Behavior does not match Power BI or expected BI standards.

Expected Result

For Boolean data type fields, Prism should display only valid aggregation functions, such as:

Count

Count Distinct

Aggregation function availability should match Power BI behavior and standard BI tool practices.

Invalid aggregation functions should be hidden or disabled for Boolean data types.

Files

Download all files
Screenshot 2026-01-29 182044.png (125 KB) Screenshot 2026-01-29 182044.png Maryam Farooq, 01/29/2026 01:27 PM
Screenshot 2026-01-29 182107.png (150 KB) Screenshot 2026-01-29 182107.png Maryam Farooq, 01/29/2026 01:27 PM
Actions
Copy link

Also available in: Atom PDF