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

Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now

Reply
Anonymous
Not applicable

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 @Anonymous ,

 

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
Anonymous
Not applicable

@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 @Anonymous ,

 

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
OCT PBI Update Carousel

Power BI Monthly Update - October 2024

Check out the October 2024 Power BI update to learn about new features.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

October NL Carousel

Fabric Community Update - October 2024

Find out what's new and trending in the Fabric Community.