Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.
Hi, @miguel-tc27
Thank you for your prompt response. Regarding your question, please refer to the following screenshots:
Secondly, If you think it's a product issue, you can create a support ticket for free and a dedicated Microsoft engineer will fix the issue for you.
The link of Power BI Support: https://powerbi.microsoft.com/en-us/support/
For how to create a support ticket, please refer to How to create a support ticket in Power BI - Microsoft Fabric Community
If you continue to share the problem and its root cause or solution after finding it, it would be great as it can help others who encounter similar issues.
Thank you for your understanding.
Best Regards,
Leroy Lu
Hi,@mshao .I am glad to help you.
You can try to write a custom function to control the size of the treemap font based on the value, or standardize it to a smaller font.
For more information about custom functions, you can refer to the following issue
Solved: Row Banding in Paginated Report with Row Groups - Microsoft Fabric Community
Create a Treemap Graph in SSRS 2016 - MSSQLTips.com
I hope my suggestions give you good ideas, if you have any more questions, please clarify in a follow-up reply.
Best Regards,
Carson Jian
Hi,@Ashe_-123 .I am glad to help you.
According to your description, you can't get more custom Visuals in Power BI Desktop using the APP Store feature.
Import Power BI visuals from AppSource or from a file - Power BI | Microsoft Learn
When accessing it, the system rejected your request, I think the problem may be in the network, please ensure that your network connection is stable.
Unable to import the visuals from AppSource - Microsoft Fabric Community
Try to clear the data cache, log back into your Power BI Service account, and if possible, use the latest version of Power BI Desktop
Solved: Unable to import the custom visual object - Microsoft Fabric Community
Try getting more visuals directly from the business app website.
Business Apps – Microsoft AppSource
I hope my suggestions give you good ideas, if you have any more questions, please clarify in a follow-up reply.
Best Regards,
Carson Jian
Hi all,
Based on the above information, It's a reproducible issue. Due to the new reply policy, I would suggest opening a Support Ticket.
If you are a Power BI Pro or Fabric 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 _ Caitlyn
Hi @a15 ,
Based on the above information, this issue is complex which may need to collect log files for further troubleshooting. Since community support engineers don't have that access, I would suggest opening a Support Ticket. If you are a Power BI Pro or Fabric 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 _ Caitlyn
Hi,@Hosamby .Very happy to see that my advice has been of help to you.
Since the definition of the calculated table itself (which is static) doesn't support it changing dynamically according to the slicer, what we can achieve is to try to restore the output of the entire table through multiple measures (which is the step you're operating on).
Thank you for your support and understanding of power BI.
Hi @Muratmet123 ,
It looks like there was a syntax error in your JSON file. The issue was caused by extra data at the end of the JSON structure.Please try :
{
"name": "Power Bi theme",
"textClasses": {
"label": {
"color": "#666666",
"fontFace": "'Trebuchet MS'",
"fontSize": 11
},
"callout": {
"color": "#666666",
"fontFace": "'Trebuchet MS'",
"fontSize": 42
},
"title": {
"color": "#666666",
"fontFace": "'Trebuchet MS'",
"fontSize": 32
},
"header": {
"color": "#666666",
"fontFace": "'Trebuchet MS'",
"fontSize": 11
}
},
"dataColors": [
"#051E50",
"#3B3B3B",
"#666666",
"#118DFF",
"#CCDAFE",
"#00C66A",
"#D64550",
"#000000"
],
"bad": "#D64550",
"neutral": "#000000",
"good": "#00C66A",
"visualStyles": {
"*": {
"*": {
"background": [
{
"image": {
"name": "Background",
"scaling": "fit",
"url": "data:image/jpeg;base64,/9j/4A"
}
},
{
"transparency": 0
}
]
},
"visualTooltip": [
{
"themedTitleFontColor": {
"solid": {
"color": "#FFFFFF"
}
},
"themedValueFontColor": {
"solid": {
"color": "#666666"
}
},
"themedBackground": {
"solid": {
"color": "#666666"
}
},
"actionFontColor": {
"solid": {
"color": "#666666"
}
}
}
],
"visualHeaderTooltip": [
{
"themedTitleFontColor": {
"solid": {
"color": "#FFFFFF"
}
},
"themedBackground": {
"solid": {
"color": "#666666"
}
}
}
]
}
}
}
Best regards.
Community Support Team_Caitlyn
Hi @Max19 ,
When you use the Format Painter, it copies the formatting but not the size. To ensure your visuals are the same size, you can manually adjust the size of each visual after applying the format. You can do this by selecting the visual and adjusting the height and width in the Format pane under the General section.
For aligning visuals equally both vertically and horizontally, you can use the gridlines and snap-to-grid features in Power BI Desktop. While there isn't a built-in feature to set a specific size gap like in AutoCAD, you can manually adjust the position of each visual using the X and Y coordinates in the Format pane under the General section.
Hope it helps!
Best Regards,
Community Support Team _ Caitlyn
Hi @Max19 ,
I did a simple test, it works fine on my end. and my test version is : 2.138.1452.0 64-bit (November 2024)
Could you download and retry via the official download link below?
Download Microsoft Power BI Desktop from Official Microsoft Download Center
Best Regards,
Community Support Team _ Caitlyn
Hi @Padycosmos ,
Thanks for your feedback! If you would like to suggest feature improvements, you may vote the idea and comment here to improve this feature. It is the right place for customers provide feedback about Microsoft Office products . What’s more, if a feedback is high voted there by other customers, it will be promising that Microsoft Product Team will take it into consideration when designing the next version in the future.
Best Regards,
Community Support Team _ Caitlyn
Hi @BakirBukvic ,
There are currently many limitations to custom visual.
If you would like to suggest feature improvements, you may vote the idea and comment here to improve this feature. It is a place for customers provide feedback about Microsoft Office products . What’s more, if a feedback is high voted there by other customers, it will be promising that Microsoft Product Team will take it into consideration when designing the next version in the future.
Best Regards,
Community Support Team_ Scott Chang
Of course! Here are some additional DAX patterns that can help you implement the FIFO method in Power BI for calculating inventory ageing quantities:
Calculate Inventory Balance: This measure calculates the running balance of inventory by considering both incoming and outgoing quantities.
InventoryBalance = CALCULATE( SUM('Inventory'[QuantityIn]) - SUM('Inventory'[QuantityOut]), FILTER( ALL('Date'), 'Date'[Date] <= MAX('Date'[Date]) ) )
FIFO Inventory Value: This measure calculates the value of the inventory using the FIFO method by considering the cost of the oldest inventory first.
FIFOInventoryValue = SUMX( FILTER( 'Inventory', 'Inventory'[Date] <= MAX('Date'[Date]) ), 'Inventory'[Quantity] * 'Inventory'[UnitCost] )
Inventory Ageing Buckets: This measure categorizes inventory into different ageing buckets (e.g., 0-30 days, 31-60 days, etc.) based on the FIFO method.
InventoryAgeing = SWITCH( TRUE(), DATEDIFF('Inventory'[Date], TODAY(), DAY) <= 30, "0-30 Days", DATEDIFF('Inventory'[Date], TODAY(), DAY) <= 60, "31-60 Days", DATEDIFF('Inventory'[Date], TODAY(), DAY) <= 90, "61-90 Days", "90+ Days" )
FIFO Cost of Goods Sold (COGS): This measure calculates the cost of goods sold using the FIFO method.
FIFOCOGS = SUMX( FILTER( 'Sales', 'Sales'[Date] <= MAX('Date'[Date]) ), 'Sales'[Quantity] * LOOKUPVALUE('Inventory'[UnitCost], 'Inventory'[Date], EARLIER('Sales'[Date])) )
For more you may refer to :DAX Patterns
Best regards.
Community Support Team_Caitlyn
Hi @amirshiloh ,
Based on the above information, It's a reproducible issue. But since community engineers no longer have a direct feedback channel with the PG team. I would suggest opening a Support Ticket.
If you are a Power BI Pro or Fabric 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 _ Caitlyn
Hi @mshao ,
Creating a superscript to name fields in Power BI Report Builder can be done by using the Text Box Properties. Here’s a step-by-step guide to help you:
1.Open Power BI Report Builder: Start by opening your report in Power BI Report Builder.
2.Select the Text Box: Click on the text box where you want to add the superscript.
3.Enter the Text: Type the text you want to display. For example, if you want to display "Field1", type "Field1".
Format the Superscript:
4.Highlight the part of the text you want to format as superscript (e.g., the "1" in "Field1").
5.Right-click on the highlighted text and select Text Box Properties.
6.In the Text Box Properties dialog box, go to the Font tab. ahd check the Superscript option.
Best regards.
Community Support Team_Caitlyn
Hi @dtatar ,
We have seen on the internal platform that other engineers have reported this issue and submitted it.
The engineers on the product team are now aware and will do their best to resolve the issue. I will update here if there is any progress. Thanks for your patience.
Best regards.
Community Support Team_Caitlyn
Hi @JoshT ,
Based on the above information, It's a reproducible issue. For the new reply policy. I would suggest opening a Support Ticket.
If you are a Power BI Pro or Fabric 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 _ Caitlyn
Hi @tounger ,
Power BI visuals might not load correctly on the first attempt due to caching or initialization issues. Clearing the search and trying again forces the visuals to reload, which might resolve the issue temporarily.
There might be a delay in data refresh or synchronization between the slicer and the table. You may ensure that the data model is correctly set up and that there are no delays in data propagation.
Best regards.
Community Support Team_Caitlyn
Hi @cqueiroz2222 ,
Try the following expression:
CC_Resultado =
VAR vCurrent = [Result]
VAR vPrevious = CALCULATE([Result], PREVIOUSMONTH(dim_Calendario[Data]))
VAR vStart = IF(ISBLANK(vPrevious), 0, vPrevious)
RETURN
IF(
vStart < 0,
vCurrent + vStart,
vCurrent)
Best regards,
Community Support Team_ Scott Chang
Hi @chippy-chip ,
Power BI expects coordinates in the order of longitude, latitude. If your coordinates are in the reverse order (latitude, longitude), this could cause issues with rendering.
Please verify that your GeoJSON file explicitly defines the geometries as polygons. if the geometries are not correctly defined, Power BI might interpret them as points. Ensure that the "type" property in your GeoJSON is set to "Polygon" or "MultiPolygon".
In the Visualizations pane, select the map visual and then go to the Format pane. Check the settings under Shape and Map styles to ensure that polygons are enabled and correctly configured.
Best regards.
Community Support Team_Caitlyn
Hi @_Judd ,
It works fine in my side.
Can you provide detailed version information so we can reproduce the issue?
Thanks in advance!
Best regards.
Community Support Team_Caitlyn