Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi @davidpowerbiwa ,
Product group has a fix for this issue and please be patient fox its deployment.
Thanks for your understanding!
Best Regards,
Community Support Team _ Caiyun
Hi @abhisub ,
You wrote the wrong rule when you set the background color.
If the field the formatting is based on contains percentages, write the numbers in the rules as decimals, which are the actual values; for example, ".30" instead of "30". Also, select Number instead of Percent for the number format. For example, "If value is greater than or equal to 0 Number and is less than .30 Number" returns values less than 30%.
A demo for your reference:
For more information,you can refer to:Color by rules for percentages
Best Regards,
Community Support Team _ Caitlyn
Hi @Anonymous
The URL you provided is not a public link , I cannot open it . Please provide a public link or a screenshot of the problem and the corresponding text description. Judging from the information you have provided so far, it is not possible to tell what the cause is.
You can also troubleshoot the issue by the following steps :
(1) Check that your data source is working correctly .
(2) If your report is published from Desktop, check whether your desktop report can display visual normally and whether the data can be successfully refreshed .
(3) If the problem only occurs in Service, then it is necessary to judge whether the credentials of this report-related dataset are correct . If the connection mode is Import , please check the path of local file .If the connection mode is Direct Query or Live Connection , please check the credentials of data source .
(4)As I mentioned in Step (3) , if your connection mode is DQ or LC , you also need check your gateway . Because the on-premises data gateway acts as a bridge to provide quick and secure data transfer between on-premises data (data that isn't in the cloud) and several Microsoft cloud services.
Best Regards,
Community Support Team _ Eason
Hi @Anonymous ,
You may create a Measure with ALL() or ALLEXCEPT() function to control the filtered used in calculation.
For more details about these two functions, please refer to ALL and ALLEXCEPT.
Best Regards,
Community Support Team _ Caiyun
Hi @Anonymous ,
According to my tests, changing the units works fine on my Power BI Desktop (Version: 2.102.845.0 64-bit (February 2022).
What data source are you using? Will this function work properly on card visual on other reports?
Best Regards,
Community Support Team _ Caitlyn
Hi @charlygirola ,
Based on the error message you provided, this seems to be due to a design conflict with Power BI, and we recommend that you localize the model using another method.
You can choose in the settings of Power BI Desktop:
For more information,you can refer to:How to localize date fields?
Or you can see if this blog can help you with your questionLocalizing the Data Model - Part 3
Best Regards,
Community Support Team _ Caitlyn
Hi @Anonymous
Based on the above information, if you are a Power BI Pro licensee, you can create a support ticket for free and a dedicated Microsoft engineer will come to solve the problem for you.
It would be great if you continue to share in this issue to help others with similar problems after you know the root cause or solution.
The link of Power BI Support: Support | Microsoft Power BI
For how to create a support ticket, please refer to How to create a support ticket in Power BI - Microsoft Power BI Community
Best Regards,
Community Support Team _ Eason
Could you share your pbix file with me ? Because my test here shows that it is normal, maybe the problem can be found from the sample you provided.
Best Regards
Community Support Team _ Ailsa Tao
Hi,
If you have an idea to help to improve the PowerBI, you can go to the Power BI Idea to submit a new idea so that people with the same idea can vote for you. I will also vote for you.
Thank you very much!
Best Regards,
Community Support Team _Robert Qin
Hi @mayarascastro ,
May I know whether you are using the latest version of Power BI Desktop? If you are using the latest Desktop and still have this problem, please try this workaround: Download the visual you need from Microsoft AppSource and then import it to your Power BI Desktop.
Link of Microsoft AppSource: https://appsource.microsoft.com//home
Best Regards,
Community Support Team _ Caiyun
Could not reproduce this issue in my side since I have use Feb 2022 version and publish to a new workspace in Power BI Service and the slicer works fine in Service.
Have you tried to publish to different workspaces? If it still happens, perhaps you can consider providing more details about this issue like Desktop version, workspace type, data source of the report etc.
By the way, glad to hear that the solution provided by @PVO3 could help you to mitigate this issue temporarily.
Best Regards,
Community Support Team _ Yingjie Li
Hi,
I think it’s still a limitation which is mentioned in the official document of this preview feature:
Thank you very much!
Best Regards,
Community Support Team _Robert Qin
Issue is caused by the security team disabled the required permission.
Hi,
According to your description, I can roughly understand your requirement, I think you can try to create another calculated column and sort the column [MonthYear Fb date] by the newly created column to achieve this:
You can create a column like this:
MonthYear Fb date1 = FORMAT('Table'[Date],"YY-MM")
Then you can sort the column[MonthYear Fb date] by the newly created column:
Then you can go to the created line chart to sort it like this:
And you can get what you want.
Thank you very much!
Best Regards,
Community Support Team _Robert Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
If you could not change the subtotal label under new format pane, please try to disable 'New format pane' feature in the options.
Best Regards,
Community Support Team _ Yingjie Li
Currently you can disable 'New format pane' feature in preview features of Options in Power BI Desktop and find 'Inner padding' in X-axis settings of bar chart to change its padding.
Best Regards,
Community Support Team _ Yingjie Li
Hi,
According to my research, a similar issue has been reported internally, so stay tuned.
Problem description: Cx downloaded the latest version Power BI Desktop from Microsoft Download Center and found the version displayed in Desktop is wrong after installation.
ICM: 289626619
I will update here once I get any information.
Thank you very much!
Best Regards,
Community Support Team _Robert Qin
Hi @Anonymous ,
May I know whether the column named ‘Number of invoice’ in your Table visual and the column called ‘Data[Document Invoice Number]’ are the same column in your Fields pane?
Please try this Measure.
Count Of Vendor Below spend of $1000 with One Invoice =
CALCULATE (
DISTINCTCOUNT ( Data[Vendor] ),
FILTER (
Data,
Data[Number of invoice] = 1
&& Data[Converted amount in USD] < 1000
)
)
Then, the result should look like this.
If I misunderstand your problem, please provide some sample data from your tables and tell me the relationships among them. If it is convenient for you, please provide a link of a sample pbix file containing your issue so I can find a solution for you. Thanks in advance!
Best Regards,
Community Support Team _ Caiyun
Have you tried to clear the browser cache and use Incognito mode to sign in Power BI Service?
If it still not works, please consider providing the Google chrome version that you have used to sign in Power BI Service.
Best Regards,
Community Support Team _ Yingjie Li