cancel
Showing results for
Did you mean:

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Helper V

## Adding a % of column on a field measure

Hello Community  -  Modifying my original post to better explain what I am trying to do.

Creating a field measure with these 4 options is easy and of course you end up with a slicer  that has these 4 options.  However, I only want to show two of them because what I actually want is when the user selects Quantity...the matrix visual should show Quantity and % of Qty.   If they select Revenue, then the matrix should only show Revenue and % of Rev.    I don't want to show all 4 options.

Perhaps I am going about this the wrong way, but I was hoping I could utilize field parameters to essentially mimic the behavior of adding the Revenue measure twice..and then having the 2nd one be the "show as % of column" option.

GDP Measures = {
("Quantity", NAMEOF('Global Demand Table'[Sum of GDP Quantity]), 0),
("% of Qty", NAMEOF('Global Demand Table'[% of Total_GDP Quantity]), 1),
("Revenue", NAMEOF('Global Demand Table'[Value by Revenue Recognition Date]), 2),
("% of Rev", NAMEOF('Global Demand Table'[% of Total_Revenue by Recognition Date]), 3)
}
1 ACCEPTED SOLUTION
Community Support

First add a new column to the parameter table:

Then create a new sliceer with the Flag column:

Final output:

Best Regards,

Jianbo Li

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

2 REPLIES 2
Helper V

@v-jianboli-msft     Perfect solution!!   So easy, and clean.   I asked ChatGPT this same question and it gave me a bunch of ridiculous solutions....

Thank you!

Community Support

First add a new column to the parameter table:

Then create a new sliceer with the Flag column:

Final output:

Best Regards,

Jianbo Li

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Announcements

#### New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

#### Fabric Monthly Update - May 2024

Check out the May 2024 Fabric update to learn about new features.

#### Fabric certifications survey

Certification feedback opportunity for the community.

Top Solution Authors
Top Kudoed Authors