Tabular report Format:

 

Step 1:

Create then custom sql with union all

SELECT [Orders$].[Category] AS [Category],

    [Orders$].[Order Date] AS [Order Date],

  [Orders$].[Product Name] AS [Product Name],

  [Orders$].[Profit] AS [Profit],

  [Orders$].[Region] AS [Region],

  [Orders$].[Row ID] AS [Row ID],

  [Orders$].[Sales] AS [Sales],

  [Orders$].[Segment] AS [Segment],

  [Orders$].[Ship Mode] AS [Ship Mode],

    [Orders$].[State] AS [State],

  [Orders$].[Sub-Category] AS [Sub-Category],

"Data" as [Alias]

FROM [Orders$]

union All

SELECT [Orders$].[Category] AS [Category],

    [Orders$].[Order Date] AS [Order Date],

  [Orders$].[Product Name] AS [Product Name],

  [Orders$].[Profit] AS [Profit],

  [Orders$].[Region] AS [Region],

  [Orders$].[Row ID] AS [Row ID],

  [Orders$].[Sales] AS [Sales],

  [Orders$].[Segment] AS [Segment],

  [Orders$].[Ship Mode] AS [Ship Mode],

    [Orders$].[State] AS [State],

  [Orders$].[Sub-Category] AS [Sub-Category],

"Total" as [Alias]

FROM [Orders$]

 

I have created one column name as [Alias]

 

Step2:

Create calculation as

case [Alias]

when "Data" then [Region]

when "Total" then [Category]

END

 

Drag this field into column and category as well.

 

Step3:

 

Create the calculation [one]

Step 4:

Drag ship mode and measure name into row .

 

Step 5:

Create the calculation with as below [Met or not met]

Step 6:

 

Drag the new calculated field [one] into row and select min

Drag [one] again to row and select min and dual axis.

 

Step 7:

Drag measure value into marks card

Step 8:

Drag  [Met or not met] into marks text

 

Step 9:

Drag sheet into dashboard and get each category total as well measure with text view.