Forum Discussion

faheem_Latif_BI's avatar
faheem_Latif_BI
Helper I
3 years ago

Slicer Data issue

Hi all, hope u all doing good,

 

im trying to figure out an issue in report created by my X colleague, 

 

here is the case 

we have a table name department and that table used in a slicer, table contains total rows (14), on desktop 14 rows apprears no issue. when we open this report in application using embadded code the slicer return 4 rows.

there is not any filter on slicer.

 

but when we create another dublicate table of department in report e.g departmentcopy and use that table in slicer all 14 rows apprear in desktop and from application , no issue at all.

 

i know its looks like a joke but it happening with me , i cant find any settings any filter ,please advise ,thanks

we are using ms sql db as a source.

 

regards 

Need Help

1 Reply

  • Shaurya's avatar
    Shaurya
    Memorable Member
    3 years ago

    Hi faheem_Latif_BI,

     

    I don't think embedded analytics has anything to do with this issue. I suggest all the page and visual level filters along with the relationships for your original table which might be getting filtered because of some field in another visual and the use of interactions.

     

    Did I answer your question? Mark this post as a solution if I did!
    Consider taking a look at my blog: How to Export Telemetry Data from Azure IoT Central into Power BI