Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

About creating a complex report

hi all As shown in the attachment, I want to focus multiple charts in one report. Now all I can think of is to use the toolbar to display, but now I need to filter in this chart.So the toolbar part ...
Need Help
  • v-juanli-msft's avatar
    v-juanli-msft
    7 years ago

    Hi Anonymous 

    You could create a column first

    date column = RIGHT('Table (2)'[Column1],2)&"/"&"01"&"/"&LEFT('Table (2)'[Column1],4)

    Then use this date column in my formula.

     

     

    Best Regards
    Maggie

     

    Community Support Team _ Maggie Li
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

v-juanli-msft's avatar
v-juanli-msft
Icon for Community Support rankCommunity Support
7 years ago

Hi Anonymous 

As far as i known, there is no such feature in Power BI.

A workaround is to:

use a button to link to a page including your visuals, then click on the button to switch among different visuals.

https://radacad.com/bookmarks-and-buttons-making-power-bi-charts-even-more-interactive

https://powerpivotpro.com/2018/04/power-bi-feature-spotlight-using-bookmark-buttons-to-create-pop-up-windows/

 

Best Regards
Maggie

 

Community Support Team _ Maggie Li
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
7 years ago

hi, v-juanli-msft 

think very much

Now I have a problem again. I want to create a new measurement value of ATA_MONTH. This field is in my excel data, but BI tells me that I do not have it when I create the measurement value

Then I want the data of ata_month to be turned into English instead of Numbers in the report. Do you know how to solve these two problems

 

 

Best Regards

alan-li