Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Sync between buttons

Hi, I'm currently working on a multilingual report using buttons and bookmarks. The idea is not to translate the data itself, but the chart titles, measures names, etc.. My report has 3 pages that...
Need Help
  • Icey's avatar
    Icey
    5 years ago

    Hi Anonymous ,

     

    Another workaround for reference:

     

    1. Create a report like so:

    Hide other pages except the Home page.

     

    2. Enter data to create a language table.

     

    2. Create Measures.

    Page Navigation Measure =
SWITCH (
    SELECTEDVALUE ( 'Language'[Language] ),
    "English", "Contents",
    "Français", "Contenu",
    "中文", "目录"
)

    Page Text Measure = 
SWITCH (
    SELECTEDVALUE ( 'Language'[Language] ),
    "English", "Click to page: Contents",
    "Français", "Cliquez sur la page: Contenu",
    "中文", "点击转到页面： 目录"
)


    Table visual title =
SWITCH (
    SELECTEDVALUE ( 'Language'[Language] ),
    "English", "Average Score",
    "Français", "score moyen",
    "中文", "平均分"
)

     

    3. Create a slicer.

     

    4. Insert a button.

     

    5. Create content pages for each language.

     

    6. Create other pages.

     

    7. Test. Here is the link.

     

    BTW, .pbix file attached.

     

     

    Best Regards,

    Icey

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Icey's avatar
Icey
Icon for Community Support rankCommunity Support
5 years ago

Hi Anonymous ,

 

Another workaround for reference:

 

1. Create a report like so:

Hide other pages except the Home page.

 

2. Enter data to create a language table.

 

2. Create Measures.

Page Navigation Measure =
SWITCH (
    SELECTEDVALUE ( 'Language'[Language] ),
    "English", "Contents",
    "Français", "Contenu",
    "中文", "目录"
)

Page Text Measure = 
SWITCH (
    SELECTEDVALUE ( 'Language'[Language] ),
    "English", "Click to page: Contents",
    "Français", "Cliquez sur la page: Contenu",
    "中文", "点击转到页面： 目录"
)


Table visual title =
SWITCH (
    SELECTEDVALUE ( 'Language'[Language] ),
    "English", "Average Score",
    "Français", "score moyen",
    "中文", "平均分"
)

 

3. Create a slicer.

 

4. Insert a button.

 

5. Create content pages for each language.

 

6. Create other pages.

 

7. Test. Here is the link.

 

BTW, .pbix file attached.

 

 

Best Regards,

Icey

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Hi Icey,

    Thanks for this second approach. I think this is the best possibility we have a fully multilingual report right now.

    We just need to consider that all the navigability in the report should be through a button instead of using tabs, but it's an approach to be considered.