topic Re: Custom Table Chart idea/Suggestion in DAX Commands and Tips

Custom Table Chart idea/Suggestion

Anonymous — Mon, 06 Feb 2023 11:57:19 GMT

Hi.

I Have a requirement to show data in a table chart but with some different view(As screenshot)
Please find the below screenshot, the custom table chart is possible in Excel but in powerbi, The below chart is not able to acheive
1,2,3,4,5,,,,, is the month numbers,
Count of City code is a measure,
Sum of Sales is a calculated column

Any Suggestions to acheive the same format in PowerBi?

Thanks

Re: Custom Table Chart idea/Suggestion

amitchandak — Tue, 07 Feb 2023 01:34:22 GMT

Anonymous , seem like you need to measure on top, Sum of sales needs to be a measure

refer: Calculation Groups- Measure Slicer, Measure Header Grouping, Measure to dimension conversion. Complex Table display : https://youtu.be/qMNv67P8Go0

Re: Custom Table Chart idea/Suggestion

Anonymous — Tue, 07 Feb 2023 07:32:12 GMT

Hi Amit,

when i create sum of sales as a calculated measure and use in Matrix chart under values sections , there is no difference

any help please?

Thanks