Forum Discussion

ALZK's avatar
ALZK
Icon for Advocate I rankAdvocate I
3 months ago

Sparkline in matrix table

Hi All, Have you ever encountered issues generating sparklines in a Matrix visual? I would like to display the "Selected KPI" value by month in a structure similar to the example below.   ...
Need Help
ALZK's avatar
ALZK
Icon for Advocate I rankAdvocate I
3 months ago

Thank you for all answers.

Regarding potential issue causes, I reduced the number of switch metrics to 3 to ensure proper testing. I also made sure all of them have an active relationship and checked Selected_KPI in the table — it correctly shows data for the particular months. However, the sparkline still does not generate.

 

  • v-priyankata's avatar
    v-priyankata
    Icon for Community Support rankCommunity Support
    3 months ago

    Hi ALZK 

    Thank you for reaching out to the Microsoft Fabric Forum Community.

    Information provided by users was helpful.

     

    Since Selected_KPI is showing the correct values for each month and all the tables have active relationships, it doesn't look like a modeling or date-filtering issue. Given that the sparkline still doesn't render even after simplifying the SWITCH logic, this may be related to how Matrix sparklines handle dynamic measures. As a quick test, can you please try creating a sparkline using one of the individual KPI measures instead of the dynamic SWITCH measure. If that works, it would help narrow down the cause. If the issue continues, In this case please reach out to support team to help on this.  Kindly raise a support ticker here How to create a Fabric and Power BI Support ticket - Power BI | Microsoft Learn.

     

    If there are any deviations from your expectation please let us know we are happy to address. 

    Thanks.