Forum Discussion

afaque03's avatar
afaque03
Icon for Helper I rankHelper I
8 years ago
Solved

Need to restrict x-axis data

Hi    I am stucked in an issue in which I just want to display the x-axis in my line chart and I dont want to display the values.     This data gets populated when i select the value 3 in ...
Need Help
  • v-juanli-msft's avatar
    v-juanli-msft
    8 years ago

    Hi afaque03

    i'm afraid there is no direct function to show as you expected.

    However, as i tested, i can work out it with a workaround.

     

     

    I can get the value of 21,22,23 when i select the value 3 in my slicer

    Measure1 =
    IF (
        MAX ( Table1[slicer] ) = 3,
        IF (
            MAX ( [hours] ) = 21,
            CALCULATE ( MAX ( [value] ) ),
            IF (
                MAX ( [hours] ) = 22,
                CALCULATE ( MAX ( [value] ) ),
                IF ( MAX ( [hours] ) = 23, CALCULATE ( MAX ( [value] ) ), BLANK () )
            )
        )
    )

     

    Then add the measure to Value Field, please note that make the "show items with no data" checked

     

     

     

    Best Regards

    Maggie 

v-juanli-msft's avatar
v-juanli-msft
Icon for Community Support rankCommunity Support
8 years ago

Hi afaque03

i'm afraid there is no direct function to show as you expected.

However, as i tested, i can work out it with a workaround.

 

 

I can get the value of 21,22,23 when i select the value 3 in my slicer

Measure1 =
IF (
    MAX ( Table1[slicer] ) = 3,
    IF (
        MAX ( [hours] ) = 21,
        CALCULATE ( MAX ( [value] ) ),
        IF (
            MAX ( [hours] ) = 22,
            CALCULATE ( MAX ( [value] ) ),
            IF ( MAX ( [hours] ) = 23, CALCULATE ( MAX ( [value] ) ), BLANK () )
        )
    )
)

 

Then add the measure to Value Field, please note that make the "show items with no data" checked

 

 

 

Best Regards

Maggie 

afaque03's avatar
afaque03
Icon for Helper I rankHelper I
8 years ago

v-juanli-msftThnx for the solutions but one issue is there If i click on slicer and select some other value it gives me blank. Can you help me with this please.