logo-wlogologo-wlogo-w
  • Home
  • Classes
  • Training
  • Consulting
  • Blog
  • Contact
✕
Find & Replace with Wildcards
April 27, 2021
Excel’s 5 Useful but rarely used Functions
September 30, 2021

5 POWER BI TRICKS THAT WILL BLOW YOUR MIND

May 19, 2021

1.While selecting the table names to get data we need to carefully check the small boxes. It can be a little difficult at times.

1

VOILA!!! We have a solution.

2. Add Mail Icon:
a. Select a text box
b. Type “*”
c. Select the star and change the font type to Windings
d. Automatically the mail icon appears. Add mail link to it

2

3. If Power BI becomes unresponsive then minimize and maximize the BI page. This works most of the time.

3

4. Group Visuals together:
a. Press CTRL key and select the visuals to be grouped
b. Right-click and select Group > Group
c. Go to formats and have a common background colour

4

Also asymmetrical visuals and text boxes can be grouped together to form a symmetrical background shape.

5. Have a pivot style layout in power bi is now just a click away.
a. Select a matrix visual
b. Select the column to add
c. Go to Format > Row Headers
d. Stepped Layout > ON / OFF

5

We can increase or decrease the indentation.

6

Contributor:Shruthi Iyengar

Qualifications: B.Sc. Statistics (Hons), Pursuing Actuarial Science

Hello,
I am an Excel and BI enthusiast and love working with numbers. I develop Excel modules for corporate training. Apart from this, I love to do Yoga and Meditation for a strong body and a healthy mind.
Shruthi Iyengar
Share
2

Related posts

December 13, 2019

November 2019 update


Read more
October 18, 2019

Spare 30 Seconds and get Insight to 6 Amazing Features of POWER BI!


Read more

Comments are closed.

✕

Categories

  • Google
  • MS Excel
  • MS Word
  • Power BI
  • Uncategorized
  • Stacking in EXCEL
    December 16, 2021
  • SIMPLE EXCEL FUNCTIONS YOU SHOULD KNOW
    December 9, 2021
  • Tips and Tricks of MS PowerPoint
    December 3, 2021
  • Circular Referencing Solution
    November 25, 2021
  • Printing tricks
    November 18, 2021
    Disclaimer Policy | Terms of Service
    Powered by Aswini Aswini Bajaj
    Website Designed & Developed by 'A PIXEL HOUSE'