Line and clustered column chart

[safina03]

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

 

[Anonymous · Accepted solution]

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]) - 60

And 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.