Power BI Exchange

Please login or click SIGN UP FOR FREE to create your PowerPlatformUG account to join this user group.

Connect with all the Power BI Users in the Power BI Exchange! All the user groups have access to this one online forum to collaboratively and instantly share their Power BI projects, wins and struggles.

Latest Discussion Posts

  • DAX for compare greater than / less than values between columns in same table

  • Thank @Ian MacIntosh . Yes referencing is an option but if its more than 50 distinct values, it would be a lot of work and would not be automated. But yes you are right, Power BI isn't built for this. May be I need to use Macros or something else for ...

  • Thanks Martin. Yes Paginated Report could be an option and then extracting in Excel but again if there are more than 50 fields then parameters would need to be passed 50 times.  You are, there may not be any solution for this in Power BI, maybe I can ...

  • duplicate fact tables are not ideal, but I've had a similar scenario where it worked. If your users will also use the dataset as a source for other PBI or Excel analysis I recommend building a separate measure table for those company-wide measures and ...

  • Profile Picture

    Need for help please

    Hello, I am looking for a solution to create a new column to determine the max of the ID_Analyse "by ID_Platform" example below. For example the max of ID_Analuse for Id_platform 5 is 858 ID_ANALYSEID ID_PLATFORM 797 ...

  • I have RLS on our data, where sales people can see data related only to their own sales. The RLS is set up with a UPN table that is joined to sales data. But we also want to show them firmwide data - e.g. we want a salesman to see that he sold six pairs ...

  • Hi This is not recommend - it is best to keep all the data in a single table so you can analyze across years... however If you really wanted to,  one way is: In PowerQuerry  Rather than duplicate the table/query - Reference it.    For example ...

  • Hi, In paginated reports it is a common feature but in Power BI it is not really available. But there is a preview feature "Small Multiples" which is very close to your requirements. But I think it works only for charts and not for a table visual. https://powerbi.microsoft.com/en-us/blog/announcing-small-multiples-public-preview/ ...

  • Hi , Can anyonehelp me with this issue?   I have a Power BI gateway set up to connect to our Oracle databases via port 1521, but am required to connect using SSL via port 2484.  I have made the necessary changes on the gateway server,  creating an ...

  • Hi,  I am looking for a way to split a Table into smaller ones, based on the column values. Let's say I have Year in a column and need to create separate tables for each year. I know, it can be done by duplicating a table and filtering it but I wanted ...

Community Blogs

  • ¿Les ha pasado que dentro de una misma sección en un cuadro de mando de Power BI, algunos usuarios prefieren gráficas de barras y otros prefieren una tabla sencilla y y quedamos analizando como cubrir esa solicitud? ¿O que algunos usuarios solicitan ...

    1 person recommends this.
  • While working in Power BI desktop, we often need to export to Excel some data sharing with customers or colleagues. Once shared, we don’t want these users to refresh the data. Coming with version 1.1.0, Power BI Sidetools exports your data into ...

  • T he Process Analytics Factory  (PAF)   announced that its latest partnership with Microsoft incorporates   PAFnow Process Mining   software with Microsoft‘s   Power Automate , a new desktop-based Robotic Process Automation (RPA) solution. ...

Volunteer Opportunities