Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreGet certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now
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 picture
Best regards
alan-li
Solved! Go to Solution.
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.
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
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.
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
Hi @Anonymous
You could create a measure
Measure = FORMAT(MAX('Table'[date]),"yyyy-mmmm")
Or a column
Column = FORMAT('Table'[date],"yyyy-mmmm")
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.
hi, @v-juanli-msft
The month worked, but my year changed to look like the one in the picture
My field is of type number,
if I change the field type to date in edit view
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
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.
Again, it's just a matter of the date
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
Hi @Anonymous
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
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
Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
User | Count |
---|---|
94 | |
92 | |
83 | |
71 | |
49 |
User | Count |
---|---|
143 | |
120 | |
110 | |
59 | |
57 |