Show CategoryID instead of the Unique ID on axis without aggregating the value

[Anonymous]

Hello,

Somehow I have the feeling this solution is easily done, but I can not wrap my head around it.

A client wants to see the ErrorCategoryID instead of the ErrorID in the X-axis, but not aggegrate the TimeDiffError. So far I tried not aggegrating, and measures with Selectedvalue and Values. So far no succes.

The table below contains ErrorCategoryID's. The values of CategoryID's should be shown individually in a bar chart. The table contains CategoryID '1' twice, value 5499 and 164. Those values should not be added together, but shown seperate with the same CategoryID (1) on the X-axis.

Any ideas how to realise this?

ErrorCategoryId	ErrorID	TimeDiffError
1	59	5499
2	60	5498
3	36	4458
4	52	2522
5	37	1462
6	47	1069
7	48	1069
8	5	1004
9	38	171
1	57	164

[amitchandak · Accepted solution]

@Anonymous , But both ErrorID and ErrorCategoryId on the axis and you can try.

Another option is charticulator. But there you have to try a few options. I have the video on the bar, see if that can help you -- Charticulator Part 1 - Bar and Bar Matrix: https://youtu.be/tKgG0arMaOw

Charticulator visual (Public Preview) :https://powerbi.microsoft.com/en-us/blog/announcing-the-new-charticulator-visual-public-preview/

[Anonymous]

Hi @amitchandak,

Thanks alot for responding, I appreciate it alot.

Your Youtube guide was perfect, I succeeded in creating the visual.

Follow-up question: normally the legend allows the user to filter/highlight the visual, with Charticulator the legend does not interact with the visual. Any solutions for this?