Hi Mohamed,

Have you read though our blog articles on slicers?

Start with this  https://www.myonlinetraininghub.com/ill-have-a-slicer-that

Regards

Phil

Hi Phil

Thanks for your immediately reply, i have checked above link and i have try in my datas but slicer option not enable.

could you please help to solve this, please see the below screen short for your reference.

Thanks/Saliha

Hello Mohamed,

As per your picture, the problem is because you are working whith an .xls file in compatibility mode. Slicers are not supported in .xls files. You need to convert your file to new file format having .xlsx as extension. You can read more about it in below link.

https://support.office.com/en-us/article/use-excel-with-earlier-versions-of-excel-2fd9ffcb-6fce-485b-85af-fecfd651a5ac

Br,

Anders

Thanks you very much for support

Please help to solve this error

regards/saliha

Hello Mohamed,

Please explain with details what the issue is, as I can't see any. I assume you expected to see some data connections, but if no data has been imported you don't have any connections. Even if data has been imported some time, the connections can be deleted.

Br,
Anders

Hi Anders

just i analyst i have a data but i am not convert in to table, its working now after i use table.

Thanks for reply