Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

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

Reply
texmexdragon2
Helper V
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
v-jianboli-msft
Community Support
Community Support

Hi @texmexdragon2 ,

 

Please try:

First add a new column to the parameter table:

vjianbolimsft_0-1686278187733.png

Then create a new sliceer with the Flag column:

vjianbolimsft_1-1686278238791.png

Final output:

vjianbolimsft_2-1686278266947.png

vjianbolimsft_3-1686278284408.png

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.

View solution in original post

2 REPLIES 2
texmexdragon2
Helper V
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!

v-jianboli-msft
Community Support
Community Support

Hi @texmexdragon2 ,

 

Please try:

First add a new column to the parameter table:

vjianbolimsft_0-1686278187733.png

Then create a new sliceer with the Flag column:

vjianbolimsft_1-1686278238791.png

Final output:

vjianbolimsft_2-1686278266947.png

vjianbolimsft_3-1686278284408.png

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.

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

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

MayPowerBICarousel

Fabric Monthly Update - May 2024

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

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.