User Profile
gmasta1129
Resolver I
Joined 4 years ago
User Widgets
Contributions
Subtotals in Matrix
I have 3 columns under the "Values" category of a Matrix. I want the Debit and Credit values to show a subtotal but the Balance value should not show a subtotal. I fixed this issue by choosing the same font color/background color which hides the subtotal in the Balance section but when its extracted to excel (Data with current layout), the amount is showing in the subtotal row. Is there a way to fix this so there is no subtotal in the Balance section of the Matrix visual?Power Automate Flow_DateTime Format for CSV file
Hello, On Power Automate, I am creating a flow where the user clicks a button and the report gets sent to an SFTP folder in CSV format. Two of the columns in my report contains date data. When the user views the Power BI table on the Power BI website, the date format is shown as mm/dd/yyyy. When I create the flow, the csv output in the SFTP folder changes the date format for those two columns to... 2027-10-26T04:00:00.000Z How would I fix the date format for these two columns to mm/dd/yyyy? Do i fix this at the "Create CSV table" step? Please see screenshot below for flow Please see screenshot for more details on the "Create CSV table" step
