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
esuryahadi
Helper I
Helper I

Help for card visual

I have the following data,

Title RKProgressField
FPP FSA AGN68,48SS
FPP FSA SS62,35SS
Bridge SS4,61TSS
Submarine (UMHK) 11,32TSS
Workshop RAM Field90SS
Renovasi Mess 52,01SS
2 Unit Boiler0TSS

 

I want to display in a visual card only the respective progress values. When I select one of the Bridge SS examples, the value will appear as 4.61. If there is no choice, the value will appear as 0. I have difficulty with this because if there is no choice, the SUM amount from the progress column will appear.

1 ACCEPTED SOLUTION

hi @esuryahadi ,

then try like:

measure = 
IF(
    ISFILTERED(data[Title RK]) || ISFILTERED(data[Field]),
    SUM(data[Progress]),
    0
)

View solution in original post

4 REPLIES 4
FreemanZ
Super User
Super User

hi @esuryahadi ,

try to plot the card visual with a measure like:

measure = 
IF(
    ISFILTERED(data[Title RK]),
    SUM(data[Progress]),
    0
)

 

it worked like:

FreemanZ_0-1698304312724.pngFreemanZ_1-1698304324188.png

 

Thank you, but i have little problem.

how if filter by field ?

 

Screenshot 2023-10-26 153159.png

hi @esuryahadi ,

then try like:

measure = 
IF(
    ISFILTERED(data[Title RK]) || ISFILTERED(data[Field]),
    SUM(data[Progress]),
    0
)

Thank you so much.

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

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

MayPowerBICarousel

Power BI Monthly Update - May 2024

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

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.