Sparkline in Table Visual

Question

Hi,&nbsp;I am trying to build the table below in Power BI but having issue to show the sparkline for different items and x-axis for 5 quarters(based on the selected quarter slicer).I have tried to used an independent date table and calculation group, but still unable show the sparkline.Attached the&nbsp;sample.pbix&nbsp;, please enlighten me on this.

naveengandhi · Answer

Hi&nbsp;changhong&nbsp;Please provide access to the PBIX so that i can have a look.
Thanks,NG

changhong · Answer

Hi&nbsp;NaveenGandhi&nbsp;,&nbsp;I have provided the access.Attached the same file in dropbox&nbsp;sample.pbix&nbsp;&nbsp;Regards,CH

anonymous · Answer

Hi&nbsp;changhong&nbsp;,According to your description, you can't create a sparkline based on a quarter. you can refer to the following documentation to learn how to create a sparkline in power bi. please note the limitations of these operations.Sparkline in Power BI - RADACADCreate sparklines in a table or matrix in a report (preview) - Power BI | Microsoft LearnSolved: Sparkline Visual - Microsoft Fabric Community
Best regards,Albert He
If this post&nbsp;helps, then please consider&nbsp;Accept it as the solution&nbsp;to help the other members find it more quickly

changhong · Answer

Hi&nbsp;Anonymous&nbsp;,&nbsp;From the first link you provided, below is the statement from the article"If you have a&nbsp;custom Date table&nbsp;created by&nbsp;Power Query&nbsp;or&nbsp;DAX&nbsp;or any other way, you can use fields such as Year-Month combination, or Year-Quarter combination, or just Year to have fewer data points in the sparkline."&nbsp;Best regards,CH

ashish_mathur · Answer

Hi,
The problem is not 'building the sparkline" - that is a simple line chart.&nbsp; Perhaps the challenge is going back 4 quarters from the choen quarter.&nbsp; I have solved a similar question in the attached files.&nbsp; Please study my solution there and adapt it to your data.
Hope this helps.

Forum Discussion

Sparkline in Table Visual

Related content

sparkline in matrix

export from visual table

Sparklines missing in table/matrix visual

Table visual error

Table Visual not Matching Calculated Visual