Forum Discussion
Line and clustered column chart
Dear Madam or Sir,
in CRM table,I have a column "Aktivitäten-Nr." that is numbers and also "Aktion" column that I want use one of the data it ,the name is "Gegenvorschläge" for filtering.I mean I just want to see the numbers that is related to "Gegenvorschläge" and after that I want to see the "Count" of numbers - 60.After that I want to put in "Line y-axis" in "Line and clustered column chart" and also in Matrix Table.
For example : 4316-60=4264
I want to see 4264 in both Chart and Table
Hi safina03 ,
If you just want to see the numbers that is related to "Gegenvorschläge", you can click on the visual object and apply "Filters on this visual" or you can create a slicer with the field "Gegenvorschläge" and select "Gegenvorschläge" in the slicer.
And if you want to see the "Count" of numbers - 60, you can choose to create a measure or calculated column like this:Numbers = COUNT('Table'[number]) - 60And put this measure or calculated column into the visual.
If these don't help, please provide some sample data or a pbix file, thanks!
Best Regards,
Dino Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
1 Reply
Hi safina03 ,
If you just want to see the numbers that is related to "Gegenvorschläge", you can click on the visual object and apply "Filters on this visual" or you can create a slicer with the field "Gegenvorschläge" and select "Gegenvorschläge" in the slicer.
And if you want to see the "Count" of numbers - 60, you can choose to create a measure or calculated column like this:Numbers = COUNT('Table'[number]) - 60And put this measure or calculated column into the visual.
If these don't help, please provide some sample data or a pbix file, thanks!
Best Regards,
Dino Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.