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.

BI_Jo's avatar
BI_Jo
Icon for Resolver III rankResolver III
5 years ago

Hi Javi,


If you are using buttons and bookmarks to switch between languages, do the bookmarks use a filter? So if you click the button for say the 'French' language the filter ticks on 'French'?  If that's the case you could just drag the filter to 'filter on all pages'.

I've done something similar for my report below, where a users clicks on the year button to filter the whole report by the year.  Note where the filter is held.

 

 

Hope that answers your question.

 

Jo

 

  • Syndicate_Admin's avatar
    Syndicate_Admin
    Icon for Administrator rankAdministrator
    5 years ago

    Hi @BI_Jo,

    Yes, I use buttons associated with bookmarks, but I'm not using any filters.

    In this case, I'm not interested in translating data, I just want a translation for the titles (that it's not a problem because there's a function for that and with a filter, this should work) but the measure's names are my main problem.

    I'm using buttons because I have all the visuals duplicated with the proper titles translated and with the measures renamed.

    Thanks for your answer!!

    Javi