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

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

Reply
Ayupchap
Helper III
Helper III

Show the details in one column whilst hiding th eothers without it distoring the figures?

Is there a way to show this graph without showing 2 of the columns and the nunbers staying the same?  I am having trouble showing this data for the High fields without showing the mid and low.  Is there anyway to hide the low and mid columsn and just show the high without the numbers distoting, I cannot seem to do this with the fitlers at all.  

 

example new.PNG

1 ACCEPTED SOLUTION
Vvelarde
Community Champion
Community Champion

@Ayupchap

 

Hi, try using this measure

 

 

Share =
DIVIDE (
    SUM ( Table4[Value] );
    CALCULATE ( SUM ( Table4[Value] ); ALL ( Table4[Type] ) )
)

Imf45.png

 

Regards

 

Victor




Lima - Peru

View solution in original post

8 REPLIES 8
Vvelarde
Community Champion
Community Champion

@Ayupchap

 

Hi, try using this measure

 

 

Share =
DIVIDE (
    SUM ( Table4[Value] );
    CALCULATE ( SUM ( Table4[Value] ); ALL ( Table4[Type] ) )
)

Imf45.png

 

Regards

 

Victor




Lima - Peru

Hi @Vvelarde

 

OK this looks amazing but I haven't done ameasure like this before in the code it says Table4{value] Wht would I need to replace these with in my instance? Sorry haven't done this before.

 

Also its stating there might be an issue also wiht the code as it said there was an issue? 

OK so I got this far and this is my error @Vvelarde:

 

error new.PNG

 

 

@Ayupchap

 

Please replace ; with , (Comma)

 

 

 

 




Lima - Peru

@Vvelarde This is working!  Thanks so much.

 

OK one more little question, see if you can help with this.  Is there a way to get this to display as a % rather than as a decimal at all?

 

 

Thanks so much

 

 

@Ayupchap

 

Select the measure in Fields Panel and go to Data Type -Format Select Percentage and number of decimals.

 




Lima - Peru

Thanks so much @Vvelarde This has been so helpful.

Helpful resources

Announcements
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

February 2024 Update Carousel

Power BI Monthly Update - February 2024

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

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.

Top Solution Authors