Matrix Format Changes When Published to Power BI Report Server
We recently upgraded to May 2024 for Power BI Report Server and we're running into a very weird problem. Maxtrixes are not allowing us to use the Tabular or Outline formatting when published. They loook fine in desktop, but once on the server, they look like the default Matrix layout. Example Below: How it looks in desktop: How it looks on the Server: This is the desktop software version: And this is the RS version: Please help! This is driving us crazy!
Publishing to report server changes subtotal column formatting. May 2022 version
When I view / edit on desktop, the formatting works as expected with the colors being uniform. When I publish to the report server, I lose the background color for the subtotal rows. The font color is assigned white, and that is normal, but the background color changes to the alternating grey / white 'default' style instead of maintaining the default color assignment.
Hiding Visuals Based On a Measure
We have BI Report Server, and our clients are slowly migrating to our PowerBi plat from. We found that when we adjust the URL clients can see all the data. I have created the below measure and added it to some visuals on the page and some visuals are hidden and some does not work. Cards, Barcharts that already have a measure in value, and the data story IsAuth = IF( ISFILTERED(qU[Is]), 1, 0 ) I followed some post and created a shape and used conditional formatting based on the measure. So it hides the visual but not only does this disable the interaction with the visual but on the web site once you load the page or refresh the page then there is a blue over lay before it turns to white or transparrent. zShapeTransparency = IF( [IsAuth] = 0, "#FFFFFFFF", -- Set color to black when IsAuth is 1 (fully opaque) "#FFFFFF00" -- Set color to fully transparent when IsAuth is 0 (using ARGB format, where FF is the alpha channel for transparency) ) Is there another way of approcing this?
Formatting Data from three tables into a dynamic report
Hi, I have three data tables I'm trying to combine into dynamic reports. They are contain unique ID keys so the relationships are in place, but I'm having trouble dispaying them in a way that is flexible enough and not incredibly complex to set up. Table 1 contains projects with various fields Table 2 contains the leads for the projects, with various fields including the project ID corresponding to table 1. Each project will have exactly 1 lead and each lead will only have 1 project. Table 3 contains other team members with various fields. There will be at least one in addition to the lead for every project, but often there will be more than one, up to around twenty. This table contains the ID for the project and lead each team member works with, and no team member will ever have more than one project/lead. I'd like to combine these into a report in a format like: Header with all project fields Project 1 Header with all lead fields Lead for project 1 Header with all team member fields Team member 1 of XX for project 1 Team member 2 of XX for project 1 .... Then the same for project 2 and so on. I can see how I would do this with code, or with a really complicated spreadsheet with lots of counts, lookups and helper collumns, but I'm hoping Power BI can help me find a simple-ish solution. Thanks for any advice!
Published dataset format is different to Desktop format
Hi, I have created a dashboard from a SharePoint list and it all the measures and conditional formatting is working fine in Desktop. However, once I have published the dashboard it's not the same. I have compared the datasets and noticed that the formatting is different which is what I think is causing the problem. In Desktop the value is pulling through a TRUE, but in Service it is pulling the value as -1, and due to this, the measure isn't picking up that the milestone has been completed. below are the examples of what I see in Desktop compared to Service. 🤔 Desktop dataset Desktop conditional formatting Service Dataset Service Conditional Formatting Any advice would be greatly appreciated. Thanks, AshVisualization Formatting Differences between Report Server and Desktop
Hello, I am adding data to an existing visualization in my organization, but it appears that there are formatting lines that separate the caregories in the Report Server view. I want to figure out how to view these lines on Desktop, and/or remove them entirely. These lines appear to be somewhat arbitrarily placed. In the screenshot below, in red, you can see that the second arrow shows that the line extends to the top of the visualization, while the third arrow shows that the line stops between the two headers. The purple arrow shows that the line in the third column was improperly placed, after the # column, instead of before it. The screenshot below shows Power BI Desktop, where these lines do not appear at all.
How to remove scientific notation from Measure in a Matrix
I have a Matrix with many measures. I have gone into Formatting > Field Formatting for every measure and set the formatting to Display units = Thousands and Value decimal places to 0. I have many data values in one column showing up in scientific notation. 2E-10, -4E-11, etc. How do I get these to show up as 0 K? The data is coming from a direct connection to an SSAS data source. For SSAS data, you cannot change the formatting on the measure in PBI Desktop. Looking at the model in Visual Studio, the measure format is Whole Number, Show Thousand Separator = True. I saw some posts suggesting using ROUND() to get rid of the digits. I literally have 1000 measures in this model and cannot make this change everywhere where I could need it.Error in visual formatting when upload to Report Server (May 2020)
Hello community, first time posting here 😀 As I want to say hi, I have some problems when upload to the report server. When I upload it look like this: Whereas it should look like this: It seems like all the backgrounds in each visual are gone. Do you guys have any ideas to solve this? I'm glad to hear your opinions. Report server: Version 1.8.7485.35104 (May 2020) File made by Power BI desktop optimized for Report server (May 2020) Thanks in advance everyone!
