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
Fabric REST API endpoint for dataflow transactions should GET *sortable* results for a time-range
Dataflow refresh APIs seem to be the buggiest; the list of transactions on a GET for Fabric-dataflow, are not sorted by the latest. OData query options such as $top, $filter, $orderby do not work wit...mangalaiyer6 hours agoNew MemberNew2Views0likes0CommentsTax on nested-pipeline orchestration patterns
Summary Fabric Data Pipelines' ExecutePipeline activity, when run with waitOnCompletion: true, has a documented but unresolved platform behavior: after the invoked child pipeline actually finishes, ...JONATHANHAUN6 hours agoNew MemberNew3Views0likes0CommentsPower BI report opens in the workspace but not in the Power BI App after .pbip + AI edits
Hello Fabric Community members, I ran into an unusual issue today and wanted to share it in case it saves someone else time. The issue: -> I developed a report in Power BI Desktop and published ...Lodha_Jaydeep8 hours agoSolution SageNew9Views0likes0CommentsEnable Multi‑Select and Bulk Delete in Microsoft Fabric Recycle Bin
Summary The recently introduced Recycle Bin in Microsoft Fabric is a very useful addition; however, it currently lacks support for multi‑select and bulk delete operations. Although the UI displays ...dwramreddy8 hours agoRegular VisitorNew153Views4likes2Comments