cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
n4tusi4
Regular Visitor

chosen item in slicer disappear from table

Hello,

When I choose from slicer period value JUL-22 then content from connected 2 tables disappear when it has the same value of period JUL-22. 

 

n4tusi4_0-1659442645851.png

n4tusi4_4-1659443022651.png

What I have already done and it didn't help:

1. I have checked already wheather there are no differences in the way how it is written in the slicer source and in table and it seems to be ok.

2. I have checked relation and all are active and well connected. 

n4tusi4_2-1659442900959.png

3. This is turned on for all tables

n4tusi4_3-1659442959518.png

4. All connected columns have the same formet setting

n4tusi4_5-1659443132623.png

 

 

Do You have an idea what might be a reason behind disappearing data from table?

One more thing I need to mention that when I choose another period then it seems to work fine what is visible in 3rd table (and for 2 above tables data disappeared what in this case is correct as there is only available data for JUL-22 ). As I just mentioned for 2 tables above is currently visible data for JUL-22 so I am not sure whether other periods would work fine for those 2 cases. I will be thankful for Your support.

 

n4tusi4_6-1659443219198.png

 

 

 

 

2 ACCEPTED SOLUTIONS
gauthamboppana
Solution Supplier
Solution Supplier

@n4tusi4  - Pleas try the below and let me know if it works.

1) Check if the periods are same in Period and GL Periods tables.
2) Do you have any visual or page level filters that are causing the tables to blank? If yes, then worth clearing the filters and test.
3) Lastly, recrate the Period slicer 

Did I answer your question? Mark my post as a solution! If not, please feel free to ask me.

Also, I would ❤ Kudos if my solution helped.  It is a token of appreciation!

Thank you very much !




View solution in original post

Hello, I needed to remove GL Periods table and create direct connection for period table for another tables. Now slicer works fine. @gauthamboppana  You might be right that in GL periods table could be a difference in names of periods but as I said I didn't check it as this table wasn't necessary and I didn't remove it in the past as connections were already created and it was easier to inert Period table (the same values as in GL periods but in requested order chronological by users) and create connection with only one table GL periods. In previous dashboards it worked but in this one was differently. Anyway thank You for suggestions 🙂

 

n4tusi4_0-1659518434355.png

 

View solution in original post

3 REPLIES 3
gauthamboppana
Solution Supplier
Solution Supplier

@n4tusi4  - Pleas try the below and let me know if it works.

1) Check if the periods are same in Period and GL Periods tables.
2) Do you have any visual or page level filters that are causing the tables to blank? If yes, then worth clearing the filters and test.
3) Lastly, recrate the Period slicer 

Did I answer your question? Mark my post as a solution! If not, please feel free to ask me.

Also, I would ❤ Kudos if my solution helped.  It is a token of appreciation!

Thank you very much !




Hello, I needed to remove GL Periods table and create direct connection for period table for another tables. Now slicer works fine. @gauthamboppana  You might be right that in GL periods table could be a difference in names of periods but as I said I didn't check it as this table wasn't necessary and I didn't remove it in the past as connections were already created and it was easier to inert Period table (the same values as in GL periods but in requested order chronological by users) and create connection with only one table GL periods. In previous dashboards it worked but in this one was differently. Anyway thank You for suggestions 🙂

 

n4tusi4_0-1659518434355.png

 

@n4tusi4  - Glad that you managed to fix it. Please can you mark my suggestions as solution if it helped, so other can find the answers quickly 🙂

Helpful resources

Announcements
September Update

Check it Out!

Click here to learn more about the September 2022 updates!

Power BI Dev Camp Session 26

Check it Out!

Mark your calendars and join us on Thursday, September 29 at 11a PDT for a great session with Ted Pattison!

Top Solution Authors