bourquejeff's avatar
bourquejeff
Frequent Visitor
9 years ago
Status:
Needs Info

Multi-row Card formats oddly when "else" string value entered for all measures in the card

This is difficult to explain without sending a screenshot. I have four measures that display dates when sliced by a particular group. the DAX for each is in this format:

6 Month Pull = IF(HASONEVALUE('Practice'[Practice Name]),VALUES('Practice'[6 Month Pull_]), "Select Group")

Before I added the "else" clause ("Select Group"), the multi-row card visual displayed (Blank) values for each measure, and the formatting was fine. When I changed the first three measures to the code above, it was fine. But when I changed the fourth measure, one of the other measures disappeared from the multi-row card, and it's "else" value displayed like a title at the top of the visual. It was very bizarre behavior, and I've tried every work around I could think of. 

 

Please let me know if there is a way I can send a visual for better diagnosis on your end.

Dashboards

3 Comments

  • v-haibl-msft's avatar
    v-haibl-msft
    Icon for Microsoft Employee rankMicrosoft Employee
    9 years ago

    bourquejeff

     

    I cannot repro the same issue on my side with Power BI Desktop version 2.48.4792.721 (July 2017), if it is possible, you can share the pbix file through online file service like OneDrive, so that I can have a try with it.

     

     

    Best Regards,
    Herbert

  • abernal's avatar
    abernal
    Frequent Visitor
    9 years ago

    Hi Herbert,

    I believe the multi-row control can no longer display text measures gracefully with the latest update of power bi desktop (2.48.4792.721 32-bit (July, 2017)). Below are two examples, one created with version Example 2.48.4792.481 32-bit (July, 2017) and another with Example 2.48.4792.721 32-bit (July, 2017). I have included a onedrive folder location, where with the images and a sample pbix file. This issue seems to appear when there are only measures selected. In some cases, when you add an attribute to the card, it seems to correct itself.

     

    Example 2.48.4792.481 32-bit (July, 2017)Example 2.48.4792.721 32-bit (July, 2017)

    For sample pbix image, you may go to https://1drv.ms/f/s!AhYq-Kv7shsJghopF6JRBZXdSEa7

     

    We would appreciate if you can correct this issue as soon as possible. Thanks,

     

    Alex 

Completed Ideas