Forum Discussion

Raju_KCS's avatar
Raju_KCS
Frequent Visitor
8 months ago
Solved

show table visual row count in KPI

Hi Experts,

 

How do I show the KPI visual to show the count of records from the table visual?

and each slicer selection show change the value

 

Thanks in Advance!

  • Hii Raju_KCS 

     

     

    To show the row count of your table visual inside a KPI, you don’t need anything special  just create a simple measure that counts rows, and the KPI will automatically change with slicers.

    •  Create a Measure:
    Row Count =
    COUNTROWS ( YourTable )

     

6 Replies

  • Hii Raju_KCS 

     

     

    To show the row count of your table visual inside a KPI, you don’t need anything special  just create a simple measure that counts rows, and the KPI will automatically change with slicers.

    •  Create a Measure:
    Row Count =
    COUNTROWS ( YourTable )

     

  • Hi Raju_KCS,

     

    You can use Card that show the KPI visual to show the count of records ! it's a new update from Power BI.

     

     

    For the slicer, you have this icons : 

     

     

     

    Hope it can help you!

    Best regards,

    Antoine

  • Hi Raju_KCS ,
    try measure below:

    Record Count = 
    VAR CurrentCount = COUNTROWS( 'YourTable' )
    RETURN
        IF( ISBLANK( CurrentCount ), 0, CurrentCount )

    By default all slicer selection will filter this.if record count becomes blank it will show zero.

     

    Please mark it as solution or give it as kudos once confirmed.

     

    Thanks and Regards,

    Praful

  • Anonymous's avatar
    Anonymous
    Not applicable

    Hi Raju_KCS,

     

    Thank you for reaching out to the Microsoft Fabric Forum Community, and special thanks to Kedar_Pande , Praful_Potphode , AntoineW  and rohit1991  for prompt and helpful responses.

    Just following up to see if the Response provided by community members were helpful in addressing the issue. if the issue still persists Feel free to reach out if you need any further clarification or assistance.

     

    Best regards,
    Prasanna Kumar

     

  • Anonymous's avatar
    Anonymous
    Not applicable

    Hi Raju_KCS,

     

    Just following up to see if the Response provided by community members were helpful in addressing the issue. if the issue still persists Feel free to reach out if you need any further clarification or assistance.

     

    Best regards,
    Prasanna Kumar