Forum Discussion

Alex1960ad's avatar
Alex1960ad
Frequent Visitor
1 year ago
Solved

Append table kpi's

I have an appended table that has two year columns, 2022 and 2023, and nine rows of financial P&L data. I want compare 2023 with 2022 column and if the data is greater in 2023 then add a traffic ligh...
  • v-aatheeque's avatar
    v-aatheeque
    1 year ago

    Hi Alex1960ad ,

    What specific metrics or columns (e.g., TOTAL_REVENUE, TOTAL_EXPENSES, etc.) do you want to compare between the years?

v-aatheeque's avatar
v-aatheeque
Icon for Community Support rankCommunity Support
1 year ago

Hi Alex1960ad ,

Thanks for reaching out to the Microsoft Fabric Community forum.

lbendlin , Thank you for the prompt response!

1.  First, ensure you have a column or measure to compare 2023 with 2022 data.

2. Use the following DAX to create the KPI column that includes the * symbol or any desired character:

KPI =

IF (

    Sheet1[2023] > Sheet1[2022],

    "@",  -- Displays the dot if 2023 > 2022

    "1"              -- Blank if condition is false

)

 

NOTE : Replace Table names, etc., with the actual table names, and with the relevant column names.


3. Apply Conditional Formatting :

  • Select the Table visual.
  • Click on the KPI column header dropdown >> Conditinal Formatiing >> Icons.

    The desired output after appending the tables is shown below:

 

 

If this post was helpful, please consider marking Accept as solution to assist other members in finding it more easily.

If you continue to face issues, feel free to reach out to us for further assistance!

 

v-aatheeque's avatar
v-aatheeque
Icon for Community Support rankCommunity Support
1 year ago
 

Hi Alex1960ad   ,
If your issue has been resolved, kindly click Accept Answer and mark Yes under "Was this answer helpful."

If you have any additional questions related to this thread, feel free to let us know, and we will do our best to assist you further.

For any new questions or issues, we kindly request you to create a new thread.