Purpose

This documentation outlines the process for creating a Power BI report that allows users to toggle between Volume-Based, Sales-Based, and ICM-Based decompositions using a single-page layout.
The report integrates three datasets:

• ICM dataset: gcp-sqo-data-pricing-d.DS_SpecialtyPolymers.V_FACT_FIDB_sales_history_icm

• Sales dataset: gcp-sqo-data-pricing-d.DS_SpecialtyPolymers.V_FACT_FIDB_sales_history_volume 

• Volume dataset: gcp-sqo-data-pricing-d.DS_SpecialtyPolymers.V_FACT_FIDB_sales_history_volume

Functional Requirements

• Toggle Switch: Three buttons/segmented control – Volumes, Sales, ICM.

• Persistent Filters: User-applied filters remain active when switching between datasets.

• Waterfall Chart: Displays decomposition (Added/Lost Key, Variation, FX Conversion, etc.).

• Data Table: Displays detailed breakdown by Market Cluster, BDM, Business Line, Region, Final Customer, Sold-to Name, H4/Product L4, Variation values.

• Filters on Report:

  • gbu_region

  • sold_to_group

  • sold_to_code

  • sold_to_name

  • market_cluster

  • h4_product_l4

  • gbu_product_family

  • product_code

  • product_name

ICM Dataset

Source: V_FACT_FIDB_sales_history_icm
Required columns:

• GBU, Market Cluster, BDM, Investor MKT Group, Business Line, GBU Region, Final Customer, Sold-to Name, Sold-to Code, H4/Product L4, GBU Product Family, Product Code, Product Name

• ICM metrics (YTD previous year, Added/Lost Key, Volume Variation, Price Variation, Variable Costs Variation, FX Conversion, YTD current year)