Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

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 Specialist
Solution Specialist

@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 Specialist
Solution Specialist

@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
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

Top Solution Authors