Hi: Need help with the below Power BI dashboard issue Issue: In the dashboard I am displaying data in tabular form. But it’s not aggregating the data (key figures) based on the key (dimensions) value. Here is the example I have the below 6 rows in my output Column1---Column2---Column3---Column4 ABC---INDIA---RED---4 ABC---INDIA---GREEN---6 ABC---INDIA---GREEN---2 XYZ---INDIA---RED---5 XYZ---INDIA---RED---8 XYZ---INDIA---RED---2 The desired output to show in the dashboard is like below ABC---INDIA---RED---4 ABC---INDIA---GREEN---8 XYZ---INDIA---RED---15 Basically numeric values need to be aggregated to the Char Key values. It’s not working for me. Am I missing any setting??? If you can help me technically to fix this, I am willing to pay for your time. Please contact me at [email protected]
3 Comments
- H0wl12New MemberIs column 4 set to Sum in aggregation?
- chass
Impactful Individual
Hello, Unfortunately this forum is for filing bugs. Luckily Marco has an example very similar here: https://social.msdn.microsoft.com/Forums/sharepoint/en-US/ae8973ad-b066-419b-90f3-11e7f225331e/equivalent-of-tsqls-if-exists-in-dax?forum=sqlanalysisservices Thanks, Chuck - fbcideas_migusrNew MemberStatus added:Completed
Recent ideas
Vertical alignment of data values
Nice addition to word wrap visual titles but... it now causes the data values to not be similarly vertically aligned if one title wraps to three rows and one to two rows. This is more prevalent with...stuartpearson8 hours agoAdvocate IINeeds Votes240Views17likes3CommentsControl Schedule Activation per Environment in Deployment Pipelines
Currently, with the new multiple scheduler feature, we can define multiple run schedules for a Fabric item. However, when using deployment pipelines, there’s no way to control which schedules are act...frithjof_v10 hours agoCommunity ChampionPlanned5.7KViews65likes13CommentsFabric Mirroring for Oracle fails on unconstrained NUMBER columns
Hi, might there be a way to Mirror Oracle database to Fabric when tabels include unconstrained NUMBER columns by setting preconditions for those as it common for Oracle databases? BR, MagnusMagnusBerglund1 day agoNew MemberNew23Views0likes0CommentsEmbedded Power BI: allow 12/24-hour clock setting independent of formatLocale
Problem In Power BI embedded reports (app-owns-data, JavaScript SDK), localeSettings.formatLocale is the only way to influence date and time display. The hour cycle (12 or 24 hour) is tied to th...VijaySama5881 day agoNew MemberNew6Views0likes0CommentsAdd Initial Horizontal Scroll Position to Matrix and Table Visuals
Please add an option to Power BI Matrix and Table visuals that allows report developers to configure the initial horizontal scroll position when the visual loads. Suggested setting: Format visual >...Panteras011 day agoFrequent VisitorNew3Views0likes0Comments