cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Helper II
Helper II

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 doesn't do the job

 

By the way, The four statements in the second picture are from the first pictureone.pngtwo.png

 

Best regards

alan-li

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support
Community Support

Re: About creating a complex report

Hi @alan-li 

You could create a column first

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

Capture20.JPGCapture21.JPG

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.

View solution in original post

9 REPLIES 9
Highlighted
Community Support
Community Support

Re: About creating a complex report

Hi @alan-li 

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...

 

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.

Highlighted
Helper II
Helper II

Re: About creating a complex report

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

test.png

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

ata_month.png

 

 

Best Regards

alan-li

Highlighted
Community Support
Community Support

Re: About creating a complex report

Hi @alan-li 

You could create a measure

Measure = FORMAT(MAX('Table'[date]),"yyyy-mmmm")

Or a column

Column = FORMAT('Table'[date],"yyyy-mmmm")

Capture7.JPG

See reference for "FORMAT"

https://docs.microsoft.com/en-us/dax/format-function-dax

 

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.

Highlighted
Helper II
Helper II

Re: About creating a complex report

hi, @v-juanli-msft 

The month worked, but my year changed to look like the one in the picture

result.png

My field is of type number,

type.png

if I change the field type to date in edit view

tran.png

My BI Desktop is in the us,This problem is driving me crazy,Can you imagine why my year is like this

 

Best Regards

alan-li

Community Support
Community Support

Re: About creating a complex report

Hi @alan-li 

You could create a column first

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

Capture20.JPGCapture21.JPG

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.

View solution in original post

Highlighted
Helper II
Helper II

Re: About creating a complex report

hi @v-juanli-msft 

That's fine, think very much

 

best regards

alan-li

Highlighted
Helper II
Helper II

Re: About creating a complex report

hi @v-juanli-msft 

 

Again, it's just a matter of the date

aa.pngbb.png

 

Just like in the picture, I have fields in my table but I still get an error

Is there a size limit on the RIGHT function, which is about 12,000 lines in this table

BI hint me not using a function that gets a single result

 

Do you know why

 

Best Regards

alan-li

Highlighted
Community Support
Community Support

Re: About creating a complex report

Hi @alan-li 

If [month] is a column, to use it in a measure, please use "MAX", or "SUM" ,,ect, for example

Measure1=Right(MAX([mONTH COLUMN]),2)

Best Regards
Maggie

Highlighted
Helper II
Helper II

Re: About creating a complex report

hi @v-juanli-msft 

 

cc.png

 

As you can see, this is a table field, But there's a lot of duplicates, and I can't delete it, so if I use the MAX function it's going to find my largest value which is 201908

I also tried using the ALL function, but it still didn't work

 

There is a troublesome way to add a column in the table to remove duplicate data, but I am not familiar with the M function, do you have an easier way? Let me know if you have. thinks

 

Best Regards

alan-li

Helpful resources

Announcements

August Community Highlights

Check out a full recap of the month!

August 2020 CYST Challenge

Check out the winners of the recent 'Can You Solve These?' community challenge!

Experience what’s next for Power BI

Join us for an in-depth look at the new Power BI features and capabilities at the free Microsoft Business Applications Launch Event.

Top Kudoed Authors